You can click the Calculate Now button in the Calculation section of the ribbon when you are ready to update your formula values.

Vba screen updating off excel video

But if you change the value of a cell included in the formula after its’ initial execution, the original value will remain.

Open the Excel file for which you wish to disable calculations. Click the Calculation Options drop-down menu in the Calculation section of the ribbon, then click the Manual option.

You can use formulas in Microsoft Excel 2010 to perform calculations based upon the values in your spreadsheet.

The benefit to using cell numbers and letters over actual values is that the formulas that you have created will update their values if you edit a cell value.

So, I prefer Open Query action rather than Run SQL action.

Regards, jon [font=Verdana][size=2]You should not have to do all that.

Everyone I have talked to has advised me to avoid using macros when possible.

Ed Disabling the screen in Access is the same as in Excel. Instead of using a macro, link your button to a subroutine and execute the queries from there.

Applying this change will simply get Excel to stop updating existing formulas when you make a change to a cell value that is included as part of the formula’s calculation.