Hi,
I have a number of files in Google Drive which many other people have access to for a number of reasons. One is a summary file which is the driver for formulas/value in 15 of the other files. However I have found when I change the driver cells nothing changes in the 15 linked docs until I actually open them, save and then close. Is there any way around this that anyone knows of where it just auto updates all of the linked files?
I have a number of files in Google Drive which many other people have access to for a number of reasons. One is a summary file which is the driver for formulas/value in 15 of the other files. However I have found when I change the driver cells nothing changes in the 15 linked docs until I actually open them, save and then close. Is there any way around this that anyone knows of where it just auto updates all of the linked files?