Formula won't recalculate?

S

slam

Well-known Member
Joined
Sep 16, 2002
Messages
871
Office Version
  1. 365
  2. 2019
What causes a formula to not update the result until you go into the formula cell and hit enter?
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Sort by date Sort by votes
Probably you have Manual Calculation switch on.

set-formulas-to-manual-calcualtion-mode-speedsheet-optimization-tips.png
 
Upvote 0
Try hit F9.

Also check in Tools > Options in Tab Calculations that Automatic is selected, in yours case probably it is Manual so you need to do it manualy by pressing F9. This is for office 2003, similar is for newer one (find Calculation Tab).
 
Upvote 0
Scary that you can turn that on/off with a workbook/worksheet that is protected.

Thanks guys!
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Force IMAGE To Connect
Replies
3
Views
140
Davey54
D
Z
  • Solved
Excel 365 Performance
2
Replies
16
Views
425
Fluff
Fluff
L
  • Question
How to stop excel converting formula to value automatically?
Replies
3
Views
447
Alex Blakenburg
A
S
  • Question
Excel ran out of resources error
Replies
1
Views
78
offthelip
O
piannetta
  • Question
Excel restarting when performing a recalculation
Replies
1
Views
162
SunnyAlv
SunnyAlv

Forum statistics

Threads
1,214,646
Messages
6,120,715
Members
448,985
Latest member
chocbudda

Share this page

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