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?