| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I email amacro? | Excel Worksheet Functions | |||
| Open last file with certain file name | Excel Discussion (Misc queries) | |||
| file is locked does not appear in Excel if file already open by an | New Users to Excel | |||
| How do you open a template at startup? | Excel Discussion (Misc queries) | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
Linear Mode
