Is it possible to link a google sheet and an excel sheet if they are both stored in google drive? I’ve started setting up a Zap, but it looks like the Excel spreadsheet needs to be stored in OneDrive, which I don’t use and don’t want to use!
Hi
You’re right that to update an Excel spreadsheet, you need to do it through a Microsoft OneDrive account, sorry about that! Is there a reason that you need to keep the sheet as an Excel sheet and haven’t converted it to a Google Sheet? Maybe we can find you a workaround here!
Hi, thanks for your reply. The excel sheet contains a lot of VBA macros and has taken years to build, converting it to a Google Sheet isn’t feasible unfortunately. Perhaps a solution is to have a ‘middle man’ excel sheet in OneDrive and link that to my main Excel sheet.
Hey there
You could utilize an Excel sheet in OneDrive! I’m curious how you’re thinking to link this back to the Excel sheet being stored in Google Drive?
Let us know and we’ll keep brain storming!
Hi Christina, I would just have both the OneDrive and Google Drive spreadsheets sync’d to the hard drive on my computer and then use native excel function to refer cells on one spreadsheet to the other. No an elegant solution though, and dependant on my computer being on.
To be honest, what I will probably do is use excel’s native ability to connect to external sources and connect to the google sheet this way.
Thanks for sharing your ultimate solution with us,
You’re right that to update an Excel spreadsheet, you need to do it through a Microsoft OneDrive account…
To be honest, what I will probably do is use excel’s native ability to connect to external sources and connect to the google sheet this way.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.