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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com