An easy way to 'cut the wait time' is to change the calculation mode in Excel. Learn about the types of calculation available, why an Excel user might want to change from one mode to another and some of the pitfalls to watch out for with manual calculation.
I have a large workbook from which I am trying to build reports, including multiple graphs. The workbook has to be in Manual Calculation mode to work. I have compartmentalized the calculations into different sheets, and written vba scripts to run calculations on different combinations of sheets. The problem I am running in to is that after I run these scripts, the graphs that I have will not update. The data does update, and if I manually go in to the graph and 'select data' and re-select the same data then they will update. Is there a way I can automate this at the end of my script? I have tried different suggestions on different forums, but nothing seems to work. Here is the code I am currently working with, but it will not update the graphs:
Apr 21, 2016 Re: Shortcut to switch to manual calculation? Hi FDibbins-guess you didn't see my original post. I was asking because someone apparently accidentally switched things to manual when it needs to always be automatic (figured it had to be a shortcut, because that's the only way it could have happened accidentally).
To recalculate the formulas in a workbook when calculation is manual, press F9 or Ctrl+= (equal sign) or select the Calculate Now button (the one with a picture of a calculator in the upper-right corner of the Calculation group) on the Formulas tab (Alt+MB). Excel then recalculates the formulas in all the worksheets of your workbook.
Thanks for taking the time to look! I am running Excel for Mac 2016. One suggestion that has been made on other forums is to momentarily set the calculation mode to automatic, but this is not an option for me, as that will crash the program.
You should be able to add co.calculate after your loop. Manual recalulate excel mac. You might also just be able to change Application.Calculation = xlAutomatic before your loop, and then change back to Application.Calculation = xlManual after the loop.
JordanJordan
Not the answer you're looking for? Browse other questions tagged excelvbaexcel-vbaexcel-vba-mac or ask your own question.