Saving work into google drive and updating when saved from a different PC

Copper Contributor

We have a stand alone desktop that is used for project planning.  It has an excel workbook containing sheets that automatically cycle through the sheets every minutes via a macro.  There are 5 people who access this file and make changes to it.  Once they save it I am wondering if there is a way to have the pc with it always up can auto update with the new changes.  

 

The file is stored on google drive, some of the people don't use OneDrive.  So co-authoring isn't an option, also because of the macro we cannot use shared workbook.

 

Any ideas would be greatly appreciated.

0 Replies