Disable Chart render cache

Question

Hi,

I have a workbook (80MB) that has a lot of charts to visualize the data. When I'm scrolling through the graphs, I see the used memory increase and I eventually get an error saying that I don't have enough resources (or a crash).

I'm using Excel 2010 and noticed that this feature was added:

"Starting in Excel 2010, the rendering speed of charts has increased, especially with large data sets, and text-rendering performance has improved. In addition, Excel 2010 caches an image of a chart and uses the cached version when possible, to avoid unnecessary calculations and rendering."

Is ther a way to turn off this caching? I don't mind if it takes longer for the charts to redraw but I need to be able to scroll through all of them to review reports

I don't know if this issue happen in earlier versions of Excel.

Note: I've tried cleaning up formating of unused cells

Thanks,

Paulo

Answer 1

Can you check if the behavior is same in other workbooks. Also have a look at this hotfix, it should help you. http://support.microsoft.com/kb/2553033/en-us