View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Laurie M. Laurie M. is offline
external usenet poster
 
Posts: 1
Default How do I link password protected files to a master spreadsheet?

I have a "master" file that several workbooks are linked to. Each individual
workbook is password protected. I would like to be able to open and update
the "master" file, however it is asking me for every individual password.
This will not work. Is there a way to "override" or to give a
"administrator" password so all the files update to the master without having
to type in each password?
Thank you.
Laurie