Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Joel, & thanks for your reply
I don't think it's got much to do with the deletes / Nothings. I played around with your suggestions, but they didn't help. Another reason why I think it's something else is, originally I was going to create ALL my graphs on one worksheet. There are 80 "indicators" in 5 categories, and each indicator has 2 graphs. So about 160 graphs in total. The reason why I mention the 5 Categories is, originally I tried with the macro putting all the indicators & graphs on a single worksheet, one after the other. At about Chart# 125 (IIRC), the processing would error, consistenly. I thought there might be a limit to the number of charts per worksheet, so I decided to split it up by Category... So now, when it's split by category, I hit the same error when I've run Category 1 about 3 times. I'm assuming I'm hitting the same limitatation I was hitting earlier, only that in a Category - by - Category basis, it's not happening in one go. I can run it for Category 1, Save & Close, Open, Run it for Category 2, Save & Close, Open.... but that's not ideal !!!! So my point is, there must be a limit to the number of Charts that I can insert in a "session", as it errors on a clean workshee. Thanks in advance.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Charts & Memory Leak?? | Excel Worksheet Functions | |||
Memory Leak in Excel | Excel Discussion (Misc queries) | |||
Memory Leak Excel 2003 vs 2000 using linked pictures | Excel Programming | |||
Excel 2003 Memory Leak | Excel Programming | |||
Memory Leak When Copying Charts | Excel Programming |