Re: Disabling Autocalculation when opening CSV files

Tech-Archive recommends: Fix windows errors by optimizing your registry

It's worth pointing out that even with manual calculation set you may till
sometimes get a recalc on opening a workbook under certain circumstances. If
the version or build of excel you're using has a different calculation engine
than the file was last saved in is the most common example.

It's not usually an issue for most folks but it's tripped up a couple of my
corporate banking clients big-time where they've been populating data using
an add-in on one box and expecting to rely on cached data elsewhere.


"Dave Peterson" wrote:

In xl2003, I can use:
tools|Options|calculatation tab
and change the calculation mode to manual.

johnmasvou wrote:

Every time I open a csv file it recalculates every possible formula in my
workbook, taking forever to open it. Is there any way to disable this from
the Excel menu options rather than in VBA?

--

Dave Peterson

.

Relevant Pages

  • Re: Overriding the calculation state
    ... The slow recalc is caused by my ... calculation to be invoked again. ... not restore them and avoid the recalc time. ... When the workbook opens I currently store the user's ...
    (microsoft.public.excel.programming)
  • Re: Overriding the calculation state
    ... Alan Moseley IT Consultancy ... The Excel Calculation Site ... The slow recalc is caused by my ... When the workbook opens I currently store the user's ...
    (microsoft.public.excel.programming)
  • Re: Overriding the calculation state
    ... (the custom function would be array-entered into multiple cells, ... The Excel Calculation Site ... The slow recalc is caused by my ... When the workbook opens I currently store the user's ...
    (microsoft.public.excel.programming)
  • Re: Overriding the calculation state
    ... Note that calculating sheet by sheet without a final recalc may NOT get the ... The Excel Calculation Site ... When the workbook opens I currently store the user's ...
    (microsoft.public.excel.programming)
  • RE: pulling data from multiple workbooks
    ... Dim MyPath As String, FilesInPath As String ... Dim Fnum As Long ... Dim mybook As Workbook, BaseWks As Worksheet ... 'Change ScreenUpdating, Calculation and EnableEvents ...
    (microsoft.public.excel.misc)