Problems with pivot tables and/or charts
My project is working OK in XL2000 but in XP or 2003 I am seeing strange
behavior.
I have 5 pivot tables in a workbook and am programmatically creating charts
and manipulating the pivot tables and copying/pasting them into sheets as
reports.
When I perform the report generation in XL2000, it works OK. In XP or 2003,
I am seeing random errors and behaviors such as repainting problems or
strange automation errors. Some of the problems a
- Error: "The object invoked has disconnected from its client". Random
places in the code.
- The pivot table worksheets won't repaint. The bottom 1/4 of the screen
is unclickable.
- In XP the (x) for close sheet is missing and I can't type any data in
any of the cells. Like the sheet is "locked".
Sometimes the reports work OK, other times it debugs on certain lines.
I rebuilt the tool entirely in a new workbook, and the same problems
persist.
Does anybody have any ideas as to what this is caused by and how to fix?
|