References

[CNeeds]

I have a Excel worksheet that reference to other worksheets that each is password protected...How can Automatically update the ENTIRE sheet (update with new data) without entering F-2 and to enter password to each cell??? Thanks in advance.

 

[kjv1611]

Can you not unprotect the sheet until the data is entered, and then reprotect it?

--

"If to err is human, then I must be some kind of human!" -Me

 

[CNeeds]

It is not protected...It just has a password to open it

 

[GlennUK]

Do you mean that you want to update references, but those references are password protected, and you don't want to have to type the password when updating? If so then open the supporting files before opening your master Excel workbook.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.