|Analyst: I'll have to get onto her computer to look at her options because I don't see anything like that on the actual workbook.|
Mike: I'm not sure what you mean by 'preview' option. I went through Options but don't see what this could mean.
Dad! No, no, not Access. Consider that a Freudian slip, I should be working on the database rather than researching this problem in Exscel (which I have never seen so don't know what she's doing when she gets the problem) but she's a manager's manager, so I have to look into it.
She mentioned Word docs too, but the Excel wb is what I am most familiar with--I created them. As far as I know, it doesn't happen to anyone else either so perhaps her own settings?
A little info on the wbs she's complaining about....it's a workbook with multiple pages which includes charts and raw data which is called by links to other workbooks.....OMG, I think I just figured it out!!!
The master workbook (hers/the manager) is fed by links from other workbooks. The person that usually opens all the wbs so they refresh each other has been out after an auto accident so if her (the employee that opens the wbs) backup is not here to open them, when the manager does, she's getting the multiple password request because ALL of the workbooks are pw protected.
I think that's it, I HOPE that's it! If it's not, I'll be back looking for more ideas!
Thanks for your input, guys!