Hi @hillbilly63_uk! 

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 @hillbilly63_uk! 
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, @hillbilly63_uk! I’ll summarize some of the thoughts here but keep us posted if you have any other q’s!