Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to NOT automatically update data for graphs in Excel 2010
I've thought about this idea, but my macro does calculations as well. If I turn calculations to "Manual", then I'm afraid it will stop my macro from working correctly. Perhaps I can "toggle" from Automatic to manual after each calculation. I'll give it a shot. FYI: Application.Calculation...- VTIE
- Post #3
- Forum: Microsoft: Office
-
How to NOT automatically update data for graphs in Excel 2010
I've got a spreadsheet with a massive macro that takes approx. 40 minutes to run with approx. 25 graphs that pull in data as the macro runs. While the macro is running, I think each of the graphs is updating itself automatically and slowing down the macro. I currently have the screen updating...- VTIE
- Thread
- Replies: 2
- Forum: Microsoft: Office
