Hi again,
I just want to add another new error that i'm getting now when i try to open
the file:

"Errors were detected in file '[file paths]'
The following is a list of repairs:

PivotTable report 'PivotTable3' on '[file name]REPORT' was discarded due to
integrity problems."

I have no idea what this means. Anyone able to help please?

Tendresse


"Tendresse" wrote:

Hi all,
I developed a spreadsheet a while ago that contained 1 pivot table that is
linked to one column in the main sheet. Above the pivot table i had a control
button to enable users to refresh the pivot table. All was working fine until
one day one of the users informed me that they are getting an error when they
try to refresh:
"Run-time error 1004: Unable to get the PivotTables property of the
Worksheet class".
The way it looks like now is that the Pivot Table actually turned flat ..
it's not pivot table anymore .. Visually, it still looks the same as the last
time it was successfully refreshed, but it's not connected to the main source
anymore. If i right-click on it, i don't get the menu related to pivot tables.
No one is giving me any clue as to how it happened or what was the last
action done before it crashes. So i'm left to guess.
Any idea what can possibly cause a pivot table to vanish? Especially that
the worksheet was password protected (to prevent curious fingers from messing
things up) and especially that the table was working fine before that? and
how can i prevent that from happening in the future? I'm using Excel 2003.
Many thanks
Tendresse