Hi Chester, awesome video. Will this work for data coming from a google form? If link the spreadsheet where the form data is collected, will it update every time someone completes the form?
Good Afternoon Chester, Great video, and I would like to try to use this. I am using a MacBook Air M2 and MS365. The Excel version is 16.81. When I go to Data, there is no selection from the Web. I could send you a screen shot or recording, but all I see is the following under Choose Data Source: EXCEL WORKBOOK, TEXT/CSV, XML, JSON, SHAREPOINT ONLINE LIST, ODATA, BLANK TABLE, BLANK QUERY. Please let me know how to proceed.
My version of Exel does NOT offer the "from web" option This is what I have as options GET DATA (Power Query) The following window opens with these options: Excel workbook - Text/CSV - XML - JSON - Share Point online list - OData - Bland Table - Blank Query. Please help Thanks.
Hi Chester, thank you for a great video as always. So useful and helpful! Please can you help me figure out how to sort date in order in excel pivot table classic mode. Currently I cannot sort the date in order. My pivot table is in classic view mode and my datasets are in the Row field. I have formatted the date using datevalue formula in the original data and it’s pulling through the pivot table fine but no matter what I try or do , it’s just not sorting the date in order. My dates are between 2021 to 2023 but they are currently not in order. Do you have any idea how I can sorts them in order without manually sorting them? Thanks in advance
Hi chester, when paste into url in excel, i encountered this problem: Details: "Relationship tag contains incorrect attribute. Line 2, position 86." can u help me to find the solution to this?
From Cambodia and say thank you for your useful video!
Great video, clear and concise. Great name BTW, I won't forget it.
Very useful and clear explanation
Very clear and to the point. Thanks
thank you so much, this is extremely easy to understand and use
Perfect ! Thank you very much
Hi Chester, awesome video. Will this work for data coming from a google form? If link the spreadsheet where the form data is collected, will it update every time someone completes the form?
Very helpful, thank you!
Good Afternoon Chester, Great video, and I would like to try to use this. I am using a MacBook Air M2 and MS365. The Excel version is 16.81. When I go to Data, there is no selection from the Web. I could send you a screen shot or recording, but all I see is the following under Choose Data Source: EXCEL WORKBOOK, TEXT/CSV, XML, JSON, SHAREPOINT ONLINE LIST, ODATA, BLANK TABLE, BLANK QUERY. Please let me know how to proceed.
I have the same problem. It seems the solution Chester presented is for PCs only. :(
Awesome video so easy and straightforward!!
this video helped me understand thanks
Very Impotent learning Thank you
GREAT, THANK YOU.
Thank You so much Sir
Excellent ❤
My version of Exel does NOT offer the "from web" option This is what I have as options GET DATA (Power Query) The following window opens with these options: Excel workbook - Text/CSV - XML - JSON - Share Point online list - OData - Bland Table - Blank Query. Please help Thanks.
Thanks for the video
Thank you!!
Hi Chester, great video, very helpful. Is there a way to do the same but import data from Excel to Google Sheets and link them?
Why, in the ultimate excel file, I see the note: External data connections have been disabled. And how to solve it? Seems like no UPDATES are done.
Hi Chester, thank you for a great video as always. So useful and helpful! Please can you help me figure out how to sort date in order in excel pivot table classic mode. Currently I cannot sort the date in order. My pivot table is in classic view mode and my datasets are in the Row field. I have formatted the date using datevalue formula in the original data and it’s pulling through the pivot table fine but no matter what I try or do , it’s just not sorting the date in order. My dates are between 2021 to 2023 but they are currently not in order. Do you have any idea how I can sorts them in order without manually sorting them? Thanks in advance
Great, unless I can´t find the button or command, "From WEB" in the microsoft Excel
What do you sugest?
it works
If don't want to expose data?
How I can i upload excel in google drive and google sheet auto import this?
Hi chester, when paste into url in excel, i encountered this problem: Details: "Relationship tag contains incorrect attribute. Line 2, position 86." can u help me to find the solution to this?
Can possible in mobile phone
❤