Integrity problems with pivot tables

J

jbaijet

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.
 
M

Mike

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
 
J

jbaijet

It runs!, thanks

Mike said:
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
Click to expand...
 
S

Sabine

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

Sabine

:confused: 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
Click to expand...
it did.
 
Top