Excel 2000 V Excel 2003

[MikeJohnB]

Hi, I have written a rather large production monitoring programme which
runs great on Excel 2000 but falls over on Excel 2003. On saving and
re-opening the spread sheet, Excel 2003 reports it cannot open the data,
it then continues to open the spread sheet but disables all the Pivot
Tables. Is there an issue with Pivot tables in 2003? have they changed
the format or something? Your assistance is much appreciated, Thank you

Mike B

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[MikeJohnB]

For information only.

It appears that Excel 2003 no longer supports multi pivot tables on one
sheet or that is my conclusion. Seperating the multi pivot tables into
seperate sheets has resolved this problem.

Mike B

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[MikeJohnB]

I hate talking to myself. The issue is not the Pivit Tables/charts at
all, it is something in the save and close routine that is causing the
programme to crash on loading which results in:

Pivot table XXX is discarded due to integrity problems
(which is repeated for all pivot tables)

I have no ideas on this issue at all Anyone help?

Mike B

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Russ]

In case you haven't found it:

http://support.microsoft.com/kb/819853

It is an error with the Save Routine, in particular the AutoSave feature.

Russ

 

[MikeJohnB]

Thanks Russ, most helpful, I had overcome the problem by re-writing the
save routine but I'm much happier knowing that it was a XP problem and
not my efforts at programming. The programme appears to work fine now
but I will disable the autorecover just in case. Cheers and thanks again
for your assistance.

Mike B

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!