Integrity problems with pivot tables

[Guest]

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 is
delivered, so, I don't know what can be the reason.

 

[Guest]

I've had similar problems that I have assumed to be caused by a recent
upgrade from Excel 9.0 to 11.0.

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.

Good Luck

 

[Guest]

Thanks a lot Mike, I will try and I will comeback with the result

 

[Guest]

It runs!, thanks

I've had similar problems that I have assumed to be caused by a recent
upgrade from Excel 9.0 to 11.0.

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.

Good Luck

 

[Sabine]

I had the same problem and search it in this Forum. Thanks all of you
..... I found the solution.

 

[Sabine]

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):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.