Calculate Sheet / Workbook (Very Useful)
Most of the time when you work on large size workbook / worksheet, you must have seen your file is taking toooo much time and going in "Calculating Mode"...
Now here is the Tip to avoid such time loss....
First convert your file to Manual Calculation mode ---> Formula ---> Calculation Option ---> Manual
Oops... but now your formula's are not updating after any updates
So now press "F9" now you can see your calculations are working fine at this time
and it will update all your open Excel workbooks.... but whatif when work in >10-15 files at a time and wanted to updated only current worksheet..... No probs... press Shift + F9 OR Alt + M + J... it will only update your current worksheet
Check this when you are working on many complex worksheets
Most of the time when you work on large size workbook / worksheet, you must have seen your file is taking toooo much time and going in "Calculating Mode"...
Now here is the Tip to avoid such time loss....
First convert your file to Manual Calculation mode ---> Formula ---> Calculation Option ---> Manual
Oops... but now your formula's are not updating after any updates
So now press "F9" now you can see your calculations are working fine at this time
and it will update all your open Excel workbooks.... but whatif when work in >10-15 files at a time and wanted to updated only current worksheet..... No probs... press Shift + F9 OR Alt + M + J... it will only update your current worksheet
Check this when you are working on many complex worksheets
No comments:
Post a Comment