Forcing users to update spreadsheets

  • Thread starter Thread starter DKerr
  • Start date Start date
D

DKerr

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?
 
Yes but I find staff tend to click no to open the spreadsheet quicker, I
wanted a to guarantee the updating of spreadsheets everytime it is
open.

Can a macro be written to automaticall choose yes?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt codes 4
Significant DELAY to open spreadsheets containing regular links? 6
Lookups - how to obtain data from a master spreadsheet into another 5
Force linked spreadsheet to open in fullsized window? 2
Likned Sheets 3
can a linked spreadsheets sort automatically when data is added 2
Excell 2000 macro will not open file! 1
Locating Source Data in Master Spreadsheet 3

Back
Top