avoid entering password on multiple spreadsheets

[franny0510]

I have 48 spreadsheets with data in them, password protected with same password.

I have one spreadsheet linking to all the 48, to collate the data.

When I open the main spreadsheet I have to enter the password 48 times to update the data.

Is there anyway to avoid entering the password 48 times?

Frances

 

[pboltonchina]

If you download and run ASAP Utilities, under the Sheets menu, Item 15 is Unprotect multiple sheets at once.

Available free from http://www.asap_utilities.com