Hapenned the same to me. You just have to create another sheet in excel and do the same process you did with the first one (data > Web > insert link > select 2° sheet (or table) > get rid of the blanc columns > put the first row as header > save), but with the newly created sheet. Hope it helps.
hi does this work if we operate the excel on website not the app? and does it support complex formula like using dropdown or checkbox features for example? thanks
I haven't tried any complex formula. It may not work with the formulas that Google Sheets doesn't support. You can use Excel online instead of Google Sheets in that case.
great video and thx for sharing it! may i ask can we use vba macro on the local connected file (which will need to search some files from the google drive source), for example "load value into cell A1 from "?
When you import the Google Sheet data, it is imported as a table in the Excel file. Later, you can remove the table formatting, but I am not sure if the connection will still work. You can try it and let me know how it goes. Thanks.
I’m trying to follow this, but am hitting a barrier when trying to import data from the web. There is a warning that my credentials could not be authenticated. Any ideas how to resolve this?
You can share the Google sheet. If you are trying to share the Excel sheet, keep the Excel file inside the OndeDrive folder, and then you can share it with other users.
Watch how to get data from Excel to Google Sheets *(auto-sync from Excel to Google Sheets)* : th-cam.com/video/hXSSehC8LTY/w-d-xo.html
Multiple sheets
So much valuable education in less than 5 minutes of content. Thank you!!!!
I want the reverse excel sheet I change I want to changes on google sheet
Lovely . Well explained. Thanks a million . With Regards from India.
This is really helpful, Thanks :)🤩
Glad it was helpful!
very good. simple to use, thanks for sharing 👍
If I make a change in the excel file does it reflect in Google sheet too??
Interesting and informative. Thanks
You are welcome
excel changed, right? can't find the "from web" option.
Yeah, did you ever find a solution?
never. asking a friend specialist on power bi i'll let you know@@ellapeterson1231
you need to add it from the customize ribbons menu in the options.
Thank you so much❤❤❤❤
You are welcome
I did everything up to the 1:17 time of your video, but i cant select both of the sheets i want to add to the excel file. Is there something i missed?
Hapenned the same to me. You just have to create another sheet in excel and do the same process you did with the first one (data > Web > insert link > select 2° sheet (or table) > get rid of the blanc columns > put the first row as header > save), but with the newly created sheet. Hope it helps.
Can we use vlookup in google sheet with ms excel(Normal excel sheet)
hi does this work if we operate the excel on website not the app? and does it support complex formula like using dropdown or checkbox features for example? thanks
I haven't tried any complex formula. It may not work with the formulas that Google Sheets doesn't support.
You can use Excel online instead of Google Sheets in that case.
If we can change any thing in excel sheet it be appear in Google sheet a???
Hi, this works only one way. Please watch this video for both wat synchronization: th-cam.com/video/hXSSehC8LTY/w-d-xo.html
great video and thx for sharing it! may i ask can we use vba macro on the local connected file (which will need to search some files from the google drive source), for example "load value into cell A1 from "?
Yes you can!
Nice
How to add multiple tables/sheets in excel from google as in From web option only 1 table/sheet can be link.
Is it possible to do in crack versions??
what if i just want specified cell intwo google sheet
Can we do the reverse ? From excel to move data to a spreadsheet ? This is what I am trying to do but I don;t know how . Thank you
Here you go: th-cam.com/video/hXSSehC8LTY/w-d-xo.htmlsi=gzVGUUQVGe7GF2L3
I didn't get the more options in properties for automate refresh the data
Select the table and select the Query tab, you will see the Properties option.
how to refresh without click refresh. mean auto generate data live
You can set auto-refresh for your desired time by following the instructions at 1:56.
which version of excel are you using?
I used the Excel that comes with Microsoft 365 Business Standard package.
Can i hyperlink google sheet to excel cell by cell not a table?
When you import the Google Sheet data, it is imported as a table in the Excel file. Later, you can remove the table formatting, but I am not sure if the connection will still work. You can try it and let me know how it goes. Thanks.
I’m trying to follow this, but am hitting a barrier when trying to import data from the web. There is a warning that my credentials could not be authenticated. Any ideas how to resolve this?
Here, Onedrive needs office 365 license. right?
You can do it with the free version as well.
I want the opposite to work with an excel file and talk to the data in Google Sheet
Here is the video: th-cam.com/video/hXSSehC8LTY/w-d-xo.html
Can we save the Excel file in Google Drive instead of OneDrive?
Yes, in that case, you won't need any third-party service.
Is that possible in not setting the privacy to public? and set it only in private?
It's private
how can I share this linked sheet with other Users
You can share the Google sheet. If you are trying to share the Excel sheet, keep the Excel file inside the OndeDrive folder, and then you can share it with other users.
Will publishing to web put my data at risk?
When publishing the data, anyone can access the data with the link.
@@technologiate What of we can keep the link without leaking
@@et.sachin In that case, it will be private. Google doesn't publish the link to the web.
Great... Will it do vice versa too? If I will work on excel and it will be updated in Google sheets ?
It doesn't work vice versa. Please watch this to sync data from Excel to Google Sheets: th-cam.com/video/hXSSehC8LTY/w-d-xo.html
One permission error for useing refresh data
nice video
Thanks
How to process muptiple sheets in GOOGLE SHEET ?
Pls respond.
1:55