Large Excel spreadsheet calculates when using VBA code to open a csv file
Posted on 2014-02-14
Environment: Windows 8.1, Excel 2013, 64 bit, 6 gigs RAM
I have a large (300 Mg) workbook which uses VBA code to open and load data from .csv files to various sheets.
When the code to open the .csv file executes, the main workbook goes into calculation mode (even though calculation is set to manual both in the excel formulas tab and in the VBA code)
This calculation can take up to 30 minutes each time a .csv file is opened ( about 12 of them).
This behavior just started, as previously over the last week of development, the .csv file would open instantly, The VBA code would copy and paste the data of interest into the appropriate sheet instantaneously.
I have used both Excel 2010 and 2013 64 bit to open the workbook and execute the code with the same results.
I tried upgrading from windows 8.0 to 8.1 and still have the same results.
Please provide some specific steps which will stop the calculation behavior until the VBA module executes a range calculate or an application calculate instruction.