Excel problem with password protected books.

  Noldi 18:36 13 Jul 2009
Locked

I have several sub Excel workbooks that take data from a main workbook. When I open a sub workbook I get prompted for the password of the main book, which I already open. (Password to open, password to modify)

Master file has personal data and the sub file gives me a print out of certain information without revealing all.

Before we updated to Office 2007 we used 2000 and this did not prompt for password as long as the master file was already open. Is this a set up problem or was this a weakness in Office 2000 that has now been changed.

Any thoughts we are helpful.



Noldi

  Noldi 18:49 13 Jul 2009

"Any thoughts we are helpful"

Any thoughts would be helpfull been a long weekend.

Noldi

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?