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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disabling Autocalculation when opening CSV files 8
Changing a csv file opened as hidden workbook 13
Closing workbook open as CSV 3
Looping Open and Save as CSV 9
calculate keeps appearing while on automatic 2
Forcing Excel to Import .CSV data 2
Load a CSV into an empty, formatted XLS? 15
Opening a .csv file thru a macro 3

Back
Top