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?

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

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

If you don't like that feature, you can make a change to the registry:

Jim Rech posted this:
http://groups.google.com/groups?thre...GP11.phx .gbl

Each recipient would have to make this same change.

James Snell wrote:

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


--

Dave Peterson

That's slightly different issue from the one I mentioned, but very useful,
I'll have to make a note of that.

The problems I've worked with relate to the fact that the entire calculation
tree is different. The instances I've worked on have been specifically
between during migrations from versions that use sheet based calculation
chains (so pre-2003) to 2003 onwards where there is a unified calculation
chain. Basically the result cache format is totally different and
incompatible with the version it's being loaded into, meaning the recalc is
unavoidable regardless of save status.

"Dave Peterson" wrote:

If you don't like that feature, you can make a change to the registry:

Jim Rech posted this:
http://groups.google.com/groups?thre...GP11.phx .gbl

Each recipient would have to make this same change.

James Snell wrote:

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


--

Dave Peterson

James,

1. The change to a global calculation chain was in Excel 2002, not Excel
2003.

2. I don't think it is correct that this change will trigger a recalc even
in Manual calculation mode:
try this test:

create a 2 sheet workbook using Excel 97 or Excel 2000

add this UDF

Option Explicit

Function Hello(theRange As Variant)
Application.Volatile
MsgBox "Hello " & theRange
End Function

in sheet1!a1 put
22
in sheet2 somewhere put
=Hello(Sheet1!a1)

Switch to Manual calculation and turn off Recalculate before save.

Press F9 to verify that you get a message on Recalc

Save the workbook as Book1 and close Excel.

Open Excel 2003
Open Book1

On my systems I do not get a Hello message until I press F9

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"James Snell" wrote in message
...
That's slightly different issue from the one I mentioned, but very useful,
I'll have to make a note of that.

The problems I've worked with relate to the fact that the entire
calculation
tree is different. The instances I've worked on have been specifically
between during migrations from versions that use sheet based calculation
chains (so pre-2003) to 2003 onwards where there is a unified calculation
chain. Basically the result cache format is totally different and
incompatible with the version it's being loaded into, meaning the recalc
is
unavoidable regardless of save status.

"Dave Peterson" wrote:

If you don't like that feature, you can make a change to the registry:

Jim Rech posted this:
http://groups.google.com/groups?thre...GP11.phx .gbl

Each recipient would have to make this same change.

James Snell wrote:

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


--

Dave Peterson