Dear all, Some times my excel sheet is not automatic calculating.
Every time I am to go Tools > Option > Calculation > Automatic
Then it can calculate automatically. But my question why the excel
Sheet turn off calculation from Automatic to Manual ( it is happing itself)
Is there any macro so that it will be remain all time automatic , even some one
Set it to Manual …br/ nur
use below method
Tools menu >> Options >> Calculation tab >> Automatic Calculation.
Thanks and Regards,
------------------------------------------------------------------------------------------
CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you. Thanks.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
Hi satputenandkumar0.
Your procedure I already mentioned in my posting. Check my posting..
then reinstall your ms office
do not reinstall office!
calculation settings in excel are determined by the setting saved with the first workbook opened. if you open a workbook saved with manual calculation first that will set calculation to manual for the whole application. if you have to have automatic calculation you need code in the workbook_open event
this code must be in the thisworkbook module of the workbook
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi JosephP, Your solution is best, thanks..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks