| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet won't recalculate
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet won't recalculate
Check the cell format... if it is text then change it to GENERAL
then edit the cell and press enter... "Humphrey" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet won't recalculate
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sheeloo" wrote: Check the cell format... if it is text then change it to GENERAL then edit the cell and press enter... "Humphrey" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet won't recalculate
Thank you. My sanity is now returning.
"Sheeloo" wrote: Check the cell format... if it is text then change it to GENERAL then edit the cell and press enter... "Humphrey" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet won't recalculate when numbers are changed. | Excel Discussion (Misc queries) | |||
| Recalculate changes only | Excel Discussion (Misc queries) | |||
| Large Spreadsheet - Freeze On Recalculate | Excel Worksheet Functions | |||
| Won't recalculate | Excel Discussion (Misc queries) | |||
| will not recalculate | Excel Worksheet Functions | |||
Linear Mode
