ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Fomulas and calculations are no longer working on my Excel Spreads (https://www.excelbanter.com/excel-worksheet-functions/107554-fomulas-calculations-no-longer-working-my-excel-spreads.html)

KC

Fomulas and calculations are no longer working on my Excel Spreads
 
I can make a formula to add up 10 + 10 and it will not calulate it for me.
Nothing works. I've been using this spreedsheet to keep up with my bills for
years and it just stopped working today.

What should I do? Thanks,

RFJ

Fomulas and calculations are no longer working on my Excel Spreads
 
Try hitting f9 to see if the sheet recalculates.

If that works it suggests that auto calculation is switched off.

Go to Tools/Options/Calculations and select automatic to switch back on
again


"KC" wrote in message
...
I can make a formula to add up 10 + 10 and it will not calulate it for me.
Nothing works. I've been using this spreedsheet to keep up with my bills
for
years and it just stopped working today.

What should I do? Thanks,




David Billigmeier

Fomulas and calculations are no longer working on my Excel Spreads
 
Try pushing F9. If that works you have calculation turned to manual. To fix:
<Tools
<Options...
"Calculation" tab
Click "Automatic"

Does that help?
--
Regards,
Dave


"KC" wrote:

I can make a formula to add up 10 + 10 and it will not calulate it for me.
Nothing works. I've been using this spreedsheet to keep up with my bills for
years and it just stopped working today.

What should I do? Thanks,



All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com