Hi Rajesh,
For the Calcuation Setting you have to go to *Tools - Options - Calculation*
**
In calculation pane there is options of :
*Automatic*
*Automatic except table*
*Manual*
**
I hope this is useful to You.
Regards,
Lavprasad Kori
MIS Executive
Hindustan Unilever Limited
Mob : 9867931351
If the spreadsheet is large, recalculation isn't something that happens quickly!
During Recalculation, if the user clicks inside of a cell, or hits the "escape"
key, or a variety of other things, then recalculation is suspended, the word
"Calculate" appears in the status bar, and Excel switches
Hi Rajesh,
If memory serves, if you open a workbook that is set to 'automatic
calculation', then open another workbook that is set to 'manual
calculation' in the same session of Excel, then both workbooks will be
set to manual calculation.
I say 'if memory serves' as this doesn't seem to occur i
1. Open your excel file which you are using.
2. Press ALT+F11
3. Open This Workbook, which you can find under Project explorer->your
excel sheet.
4. Paste the below code.
Private Sub Workbook_Open()
Application.Calculation = xlCalculationAutomatic
End Sub
Let me know if t
Use these steps
Tools > Options > Under calculation , click on Automatic and click OK
Problem will be resolved.
On Thu, Feb 26, 2009 at 12:00 PM, Rajesh Srinivasaraghavan <
taur...@gmail.com> wrote:
> Hi,
> I have come across instances where the calculation settings have got
> modified from Cal