Opening csv file without recalculating

[njimack]

Morning all

Whenever I open a csv file either manually or via VBA, Excel insists on recalculating every file that's open, even though I have calculation set to manual.

This is making macros take much longer than they should and often causes errors where files are linking to a closed workbook.

Can anyone suggest a method of avoiding this recalculation?

 

[Jon von der Heyden]

Import the CSV data into a new workbook and sheet so that the file doesn't need to be opened.

 

[njimack]

Great idea! Don't know why I didn't think of that.

Thanks