Excel won't calculate

6kbailey

New Member
Joined
Nov 17, 2005
Messages
1
I have created a large spreadsheet with many references within the spreadsheet. At some point, the references in cells stopped updating unless I manually enter into the cell and push enter. For instance - in one cell I reference G13 on another tab - if I go to G13 on the other tab and modify the number and come back to the cell that references it, the old number remains. The only way to get the cell to update is to click my cursor into the cell reference and push enter.

I have had this problem once before - excel not calculating. Always in conjunction with very large spreadsheet. I know that there are not circular references which affect the calculations in question, also, I have made sure that "automatic" is chosen in the options tab.

Do you have any ideas on what I can do?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Welcome to MrExcel - have you checked to see if calculation is set to automatic?

Tools | Options | Calculation tab
 
Upvote 0

Forum statistics

Threads
1,224,427
Messages
6,178,588
Members
452,860
Latest member
jroberts02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top