Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatic calculations
I have tried to change the calculations in my spreadsheets to automatic from
manual and then saving it into the xlstart folder, BUT this is not working. Other users use these spreadsheets and are not familiar with the F9 to recalculate. Please help!! Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatic calculations
How did you change it, and what did you save in the xlstart folder?
"Kelseyk" wrote: I have tried to change the calculations in my spreadsheets to automatic from manual and then saving it into the xlstart folder, BUT this is not working. Other users use these spreadsheets and are not familiar with the F9 to recalculate. Please help!! Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatic calculations
Hi,
I changed it in book1, saved it as a template and put it into my xlstart folder. I also tried saving it as book and doing the same.. Thanks "kassie" wrote: How did you change it, and what did you save in the xlstart folder? "Kelseyk" wrote: I have tried to change the calculations in my spreadsheets to automatic from manual and then saving it into the xlstart folder, BUT this is not working. Other users use these spreadsheets and are not familiar with the F9 to recalculate. Please help!! Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatic calculations
Hi Kelsy,
I actually wanted to know what you did to change it. Calculation is changed by clicking on Tools|Options, selecting the Calculation tab, and selecting Automatic calculation, that's it. Nothing to save after that. If the option block before Automatic is ticked, that means that all sheets will be calculated automatically. "Kelseyk" wrote: Hi, I changed it in book1, saved it as a template and put it into my xlstart folder. I also tried saving it as book and doing the same.. Thanks "kassie" wrote: How did you change it, and what did you save in the xlstart folder? "Kelseyk" wrote: I have tried to change the calculations in my spreadsheets to automatic from manual and then saving it into the xlstart folder, BUT this is not working. Other users use these spreadsheets and are not familiar with the F9 to recalculate. Please help!! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic and manual calculations | Excel Discussion (Misc queries) | |||
Automatic and manual calculations | Excel Discussion (Misc queries) | |||
why does the tools-options calculations reset to automatic after | Charts and Charting in Excel | |||
options to update automatic links | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) |