Can you pause Charts from updating while an array fills in the source data?

Infidel Rob

New Member
Apr 26, 2010
I am trying to speed up one of my macros. The macro in question fills an array with data from the "Data" workbook, and then dumps it into a sheet in the "Charts" workbook. Loading the data takes a second or two, dumping it takes more than 90! (dumping it into a blank workbook also takes just a second or two.)

Having encountered something similar with formulas before, I have used Application.Calculation to turn off calculations (manual) prior to the loops that dump the array, and then turn it back on (automatic) after the dump, but this has not had the effect I expected.

The only thing I can think of is that this data feeds the various charts that exist in the "Charts" workbook (surprise!) and that they keep updating themselves as I dump the array. And that this updating isn't considered calculation as described above.

Is there another means of keeping the charts from updating until after the array has finished filling in the source data? Or do I just have to get used to a longer run time than I would like?

Thanks for any help you can provide.

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics