Dear All, the solution works yesterday, but today, when I
opened the file, the problem appear again .... Are there any solutions
for it?

*Problem* (same as below written by another Member):
I have deployed several pivot tables in one Excel file. I save and
close the
file and no problem appears. When I try to open again the file, the
system
asks me if I want to enable macros and after that, Excel asks me
too for
the password of the file. When I put the password, a message like
that
appears: "Unable to read file". Inmmediatly, and without any other

action, the system tries to open again the file and again, Excel
asks me if
I want to enable the macros and Excel asks me too for the password.
In
this second time, the file is opened, but, a new message appears
telling
me that all the pivot tables are unlinked because there are
"Integrity
Problems". No more information isdelivered, so, I don't know what
can be the reason.

*Solution* (wrote by Mike):

I was able to fix my problem by changing the pivot table options so
that the
"refresh on open" box was checked. I have no idea why this works, but
it did.


--
Sabine
------------------------------------------------------------------------
Sabine's Profile: http://www.excelforum.com/member.php...o&userid=34800
View this thread: http://www.excelforum.com/showthread...hreadid=522088