Spreadsheet won't recalculate

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
 
S

Sheeloo

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

Shane Devenshire

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.
 
H

Humphrey

Thank you. My sanity is now returning.

Sheeloo said:
Check the cell format... if it is text then change it to GENERAL
then edit the cell and press enter...
Click to expand...
 

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

Formula's won't read copy / pasted data ? 2
Recalculate based on 3 of 4 variables. 2
How do I get rid of the link cell showing the linking formula 1
EXCEL SPREADSHEET IS NOT RECALCULATING 2
Spreadsheet won't recalculate when numbers are changed. 1
copying excel cells with formulas 4
Copy Existing Formula Into New Row 0
Formula problems 2

Top