Open a file WITHOUT calculation

[brianmock]

I am using the workbooks.open method to open a .csv file and it auto calculates... how can I stop this

My code is:
wb_path =
wb_name =
workbooks.open Filename:= wb_path & wb_name

I have tried to use
(1) Application.Calculation = xlCalculationManual before the open statement
(2) UpdateLinks:= 2 after the open statement

I have set calculation to manual
the file I am opening is a .csv data file placed daily

Is there another way to open files without excel calculating?

 

[Debraj]

the file I am opening is a .csv data file placed daily

Are you sure.. the CSV file contain some FORMULA which are updating on opening..

No buddy.. the calculation is must be in ThisWorkbook.. please re-check code.. or describe briefly..

 

[brianmock]

Maybe the file that has the macro in it is causing the calculation... I have checked the settings though.

What setting am I missing? I have checked in Excel Options > Advanced and Formulas ??