Formula values not updating excel
Fortunately you can make Excel 2010 stop updating your formula totals whenever you make a change to a cell and instead execute all of your formula calculations manually.
Note that this method will not stop Excel from executing formulas that consist of only numbers and mathematical operator symbols.
Hopefully one of them will get you where you need to go.
Note that the first one ignores the request to do this as a formula since that solution is not pretty.
In the tooltip that is shown in the screen shot below, you can see that the shortcut for Calculate Sheet is Shift F9.