Re: Disabling Autocalculation when opening CSV files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Jim Rech posted this:
http://groups.google.com/groups?threadm=uzkujhMHEHA.3284%40TK2MSFTNGP11.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
.

Relevant Pages

  • Re: Disabling Autocalculation when opening CSV files
    ... The problems I've worked with relate to the fact that the entire calculation ... "Dave Peterson" wrote: ... sometimes get a recalc on opening a workbook under certain circumstances. ... corporate banking clients big-time where they've been populating data using ...
    (microsoft.public.excel.programming)
  • Re: save as csv cell format
    ... Public Sub DoTheExport() ... Dim FName As Variant ... "Dave Peterson" wrote: ... - I run the Macro Save-As CSV and the Column C in the CSV file becomes ...
    (microsoft.public.excel.programming)
  • Re: save as csv cell format
    ... "Dave Peterson" wrote: ... Dim myCurFolder As String ... Open that CSV file in NotePad to check it out. ... I 'saveas' the file in *CSV format and when I open the CSV file the date ...
    (microsoft.public.excel.programming)
  • Re: How do I allow blank columns in a .CSV file?
    ... I am using the csv file to upload data from excel to a website - the website ... "Dave Peterson" wrote: ... not buying much by making sure that there are extra commas in the file. ...
    (microsoft.public.excel.misc)
  • Re: how do I get the comma delimited feature to work in excel
    ... Do you save the .csv file to the harddrive first, then double click on it to ... correctl. ... "Dave Peterson" wrote: ... I just checked it and it is a comma ...
    (microsoft.public.excel.misc)