How to open xls file without recalculation?

[nomail1983]

Is there a way to open an xls file without causing recalculation?

I know that if the xls file were saved with the Calculation option set
to Manual and not Recalculate Before Save (for extra measure), I can
subsequently open the file and there will be no recalculation.

But I am asking about an xls file that I did not save -- for example,
an xls file that is sent to me, and I have no control over the
calculation options that were selected.

 

[Pete_UK]

I think if you start Excel and set the Calculation option to Manual
then do File | Open on your file, the file will inherit the manual
calculation setting.

Hope this helps.

Pete

 

[nomail1983]

I think if you start Excel and set the Calculation option to Manual
then do File | Open on your file, the file will inherit the manual
calculation setting. Hope this helps.

Ah, the one combination I failed to try. Yes, that works great.
Thanks.

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Ah, the one combination I failed to try. Yes, that works great.
Thanks.

 

[Gord Dibben]

Open another Excel workbook first.

Set Calculation to Manual.

Open the next workbook and calc mode will be manual also, no matter which mode
it was saved in.


Gord Dibben MS Excel MVP