How to open xls file without recalculation?
 

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.

How to open xls file without recalculation?
 

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

wrote:
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.

How to open xls file without recalculation?
 

Pete_UK wrote:
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.

How to open xls file without recalculation?
 

You're welcome - thanks for feeding back.

Pete

wrote:
Pete_UK wrote:
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.

How to open xls file without recalculation?
 

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

On 17 Aug 2006 00:25:25 -0700, wrote:

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.