Integrity problems with pivot tables
 

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.

Integrity problems with pivot tables
 

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
--
Mike


"jbaijet" wrote:

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.

Integrity problems with pivot tables
 

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

"Mike" wrote:

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
--
Mike


"jbaijet" wrote:

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.

Integrity problems with pivot tables
 

It runs!, thanks

"Mike" wrote:

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
--
Mike


"jbaijet" wrote:

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.

Integrity problems with pivot tables
 

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


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

Integrity problems with pivot tables
 

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