Turning off automatic calculation when opening a CSV file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way in which to prevent excel from automatically re-calculating
all open workbooks when opening a CSV file? I have set through Tools|Options
the manual calculation option with recalculate before save switched off and
also, in the code for opening the CSV file, I have used:
With Application
.Calculation = xlCalculationManual
.CalculateBeforeSave = False
End With
However, still my entire Excel session recalculates when the CSV file opens.
Any suggestions?
 
Hi Will,

Have you try to disable the this code? by putting ' in front.

'With Application
' .Calculation = xlCalculationManual
' .CalculateBeforeSave = False
'End With

Or maybe you can increase the Macro Security to High Level, Tools, Macro,
Security, High.
 
Mel,
That won't have any impact as the worst it would do is to set calculation to
manual, which is what I want to do anyway. The only solution I've found so
far is to import data from a CSV file using the data import tool, which gets
around the problem partially, although it's a sub-optimal fix.
 
Back
Top