Spreadsheet won't recalculate

  • Thread starter Thread starter Humphrey
  • Start date Start date
H

Humphrey

I have a 25MB spreadsheet that has stopped recalculating newly entered
formulas. If I enter =A4 into a cell the value from A4 is not returned but
shows =A4. All previously entered formulas work its just the new ones that
fail. Any ideas?

H
 
Check the cell format... if it is text then change it to GENERAL
then edit the cell and press enter...
 
Hi,

Make sure the cells aren't formatted as Text.

If you see formulas for all the formula cells rather than their values
choose Tools, Options, View tab and uncheck Formulas.

Finally, check Tools, Options, Calculation and make sure you are on Automatic.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recalculate based on 3 of 4 variables. 2
Reference Cell Altering Formulas 1
Nested if text search 2
Cell formulas are not recomputing 2
Custom Function Won't Auto-Calculate 5
IF & AND combination not working 5
Spreadsheet won't recalculate when numbers are changed. 1
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) 4

Back
Top