I run a main spreadsheet linked to 40 individual spreadsheets used by others. I would like to force users to update their spreadsheet when opening. How could this be best done? I was hoping there may be a way for drop down lists in the 40 spreadsheets to remain empty unless they update. Can this be done? or is there a better way?
Bookmarks