We have a number of multi-year spreadsheets for collecting and analyzing
monthly costs for a small business. Every month, we delete the oldest month
and insert a new month (delete a row or column and add a new one at the
opposite end of the spreadsheet). Excel, however, automatically changes our
formulas (total cost, average cost, total one year ago, etc.) because the
data moved on the spreadsheet; and we have to manually update all the
formulas. Is there any way to stop auto formula update?