Formulas suddenly won't work

[Guest]

I'm having a strange problem with my Excel spreadsheet. Up until a couple of
weeks ago, all the formulas in my spreadsheet worked fine, could be cut and
pasted, and automatically refigured when I would input new data. Within the
past couple of weeks, the spreadsheet has stopped doing all of the above. If
I input new data, I have to retell it to sum and it will not copy and paste
formulas. Does anyone have any idea why it would suddenly stop working?

Thanks for the help!

 

[Niek Otten]

Tools>Options>Calculation tab, check Automatic calculation

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm having a strange problem with my Excel spreadsheet. Up until a couple of
| weeks ago, all the formulas in my spreadsheet worked fine, could be cut and
| pasted, and automatically refigured when I would input new data. Within the
| past couple of weeks, the spreadsheet has stopped doing all of the above. If
| I input new data, I have to retell it to sum and it will not copy and paste
| formulas. Does anyone have any idea why it would suddenly stop working?
|
| Thanks for the help!

 

[Pete_UK]

Sounds like it is set for manual re-calculation. Go to Tools | Options
| Calculation tab, then ensure that Automatic is checked then OK.

Hope this helps.

Pete