What happened to AutoCalc in Excel 2010?

J

jdunlap

Board Regular
Joined
May 27, 2009
Messages
86
Recently switched to 2010 and now files others are sending me do not auto-calculate...I keep having to hit F9 to force it to calculate. Tried to find the checkbox for AutoCalc in Options but they've apparently changed the name. Can anyone point to the right place to make sure my spreadsheets will auto-calculate when I make changes? Thanks!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Sort by date Sort by votes
File tab, click Options, click Formulas, check Automatic under Workbook Calculation.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Formula Calculation is Inadvertently Switching from Automatic to Manual...
Replies
0
Views
262
MNexcelguy19
M
J
  • Question Question
Excel Compiled VBA Corruption - Why Does It Happen?
Replies
2
Views
588
Fluff
Fluff
J
  • Question Question
Forced to discard digital signature after opening and immediately saving an Macro-Enabled Excel file
Replies
0
Views
572
JDCreate
J
afrazier1221
  • Solved
Bizarre Listbox Population Issue
Replies
5
Views
506
Akuini
Akuini
D
  • Question Question
Tally that shifts cells daily.
Replies
3
Views
813
portews
P

Forum statistics

Threads
1,224,585
Messages
6,179,704
Members
452,938
Latest member
babeneker

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