If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel creates its own hidden charts that creates a corrupt file!
While running a VBA macro, Excel 2000 creates charts of its own which only
appear in the "Project Explorer" of the file. [It is interesting to note that the longer the code runs (i.e. days) the more charts Excel has created.] The moment Excel creates these "hidden charts," the file can no longer have a copy made (via SaveCopyAs or any other means) without this copied file causing that instance of Excel to crash because the file is corrupt. And therefore, the moment Excel creates these "hidden charts," you need to rebuild the file that just went corrupt. However, the "corrupt" file can still run while it is open, but it will be corrupt if the user closes it. (Lesson: Don't close the file) Can anyone help me figure out what it is about my code that might cause this? Has anyone ever seen this before? Because I am sick and tired of having to rebuild my code when someone else closes the file. ------ There is only one pre-existing chart in my program and I have seen Excel create up to 22 new charts that I can’t find or delete. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Splitting large Excel csv file | Rick | General Discussion | 2 | July 8th, 2004 02:39 AM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Size of Excel file Access db exports to. | Tasha | General Discussion | 2 | June 5th, 2004 01:48 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Corrupt excel file crashes | Quan | Setting up and Configuration | 1 | November 10th, 2003 07:04 AM |