password protected file with pivot table errors
 

Hey friends,

We have a big problem, around 20% of the times we save workbooks with pivot
tables inside and protect them with password for opening the file - the file
get ruined!

In those times, when we open the file (the password protected file with the
tables inside), excel ask me for the pass (ok, I give it) and then say "file
opening did not succeeded", and then let me type again, in the second time it
opens but give a message saying "there where errors in the file, and changes
where made:" (and then a list of my pivot tables saying that fixes made to
them).

From now on, the pivot tables are just values, no more dynamic, unchangeable!

It is very frustrating, and Microsoft in my country (Israel) although they
where very nice, say that they don't know about it...

Please help

Thank you very much, and have a great week,

Tal