Calculation mode sets to Manual

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

My calculation mode sets to manual everytime I save or
open Excel. Please help
 
Calculation mode is set by the first workbook opened in an XL
session. Check your file that you use to start XL, or, if you start
the application first, check the items in your startup folder
(including Personal.xls).
 
Try saving a new workbook
with the calculation mode set to Automatic
as Book.xlt in XLSTART folder
(template file)

Open a new (empty) book

Click Tools > Options > Calculation tab > Check "Automatic" > OK

Click File > Save As:

Select under "Save as type:" : Template

Put as "File name:" : Book

Navigate to (for "Save in:"):
C:\Program Files\Microsoft Office\Office\XLStart

Click Save
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent Manual Calculation Mode 1
manual calculate 5
Reset workbook back to Auto Calculate 8
Why doesn't Excel understand what 'Manual' for Calculations? 4
Setting Manual Calculation on Specific Cells Only 3
Spreadsheet constantly reverts to manual calculation mode 3
AUTOMATIC CALCULATION RANDOMLY SWITCH TO MANUAL? 2
What are the steps to fix damaged MDF files in SQL Server? 0

Back
Top