Include an extra blank row/column in your formula, this way, when deleting
the last row/column on data, the actual last row/column will not be affected.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"jch" wrote:

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?