Formulas

  • Thread starter Thread starter Tonya Morris
  • Start date Start date
T

Tonya Morris

I have two spreadsheets, one that I have a year's worth
of data on, and another that has 4 months worth of data.
It is all financial reports and has formulas in them.
When I start a new month I always copy a worksheet, with
the formulas and change my numbers. They have always
worked fine. Friday, I copied my worksheets and erased
the old numbers, so I could start fresh today for Dec's
report. My formulas are still where they are supposed to
be, but when I add the new numbers the formulas don't
respond. If I reenter the formulas it works, but then if
I change the numbers the formula stops working. I opened
my spreadsheet from last year and it is doing the same
thing, but if I open a new document they work fine. I
don't want to have to retype all of this data, can any
one help me?
 
Try this, after you have entered the new data, do an edit>replace and
replace what = with =
(replace the equal sign with the equal sign)
That usually works for me when these things happen, it usually forces the
formulas to calculate
Before you do this make sure the formula cells are not text format
 
Tonya,
Check under Tools>Options>Calculation and make sure it is set to Automatic. This might have been set to Manual by another workbook.

Good Luck,
Mark Graesser

----- Tonya Morris wrote: -----

I have two spreadsheets, one that I have a year's worth
of data on, and another that has 4 months worth of data.
It is all financial reports and has formulas in them.
When I start a new month I always copy a worksheet, with
the formulas and change my numbers. They have always
worked fine. Friday, I copied my worksheets and erased
the old numbers, so I could start fresh today for Dec's
report. My formulas are still where they are supposed to
be, but when I add the new numbers the formulas don't
respond. If I reenter the formulas it works, but then if
I change the numbers the formula stops working. I opened
my spreadsheet from last year and it is doing the same
thing, but if I open a new document they work fine. I
don't want to have to retype all of this data, can any
one help me?
 
Back
Top