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.
thank you Chester, very usefull Video. Iam From Indonesia. Would you help me, why at my google sheets, i already into menu Publish Web, when i sellect only one Table name of google sheets..there is no option for publish to microsoft excel. thank you Chester
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?
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?
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.
I was born yesterday after seeing this video, thank you!
From Cambodia and say thank you for your useful video!
Great video, clear and concise. Great name BTW, I won't forget it.
Very clear and to the point. Thanks
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. :(
thank you Chester, very usefull Video. Iam From Indonesia. Would you help me, why at my google sheets, i already into menu Publish Web, when i sellect only one Table name of google sheets..there is no option for publish to microsoft excel. thank you Chester
Awesome video so easy and straightforward!!
thank you so much, this is extremely easy to understand and use
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?
Thank You! Stay Blessed!
Very useful and clear explanation
this video helped me understand thanks
Very helpful, thank you!
Very Impotent learning Thank you
How I can i upload excel in google drive and google sheet auto import this?
Perfect ! Thank you very much
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
Excellent ❤
Great, unless I can´t find the button or command, "From WEB" in the microsoft Excel
What do you sugest?
GREAT, THANK YOU.
Thank You so much Sir
Thanks for the video
the 'from web' option is not supported on mac any ideas ?
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?
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?
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.
Thank you but the Refresh every X minute option only works when the file is Open... which is not very useful when the goal is to automate...
Can possible in mobile phone
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.
it works
If don't want to expose data?
❤