Hello,
I am using a large excel file as my database. I have around 100 csv files with the price data which are each linked to the separate sheets in this excel workbook. One cell controls which of the sheets supply the data to the main sheet which in turn is linked to a few other large excel model files which recalculate using the data from the main sheet. I noticed that those large excel files take longer to recalculate (some use macros which make them recalculate dozens of times) when the main data file is open. Apparently excel recalculates it as well.
I wanted to ask how you think this can be accelerated?
1) Do I set up an Access data base with separate tables for each of the CSV files and import then into the main data file when I need to update it with the new data?
2) Or do I just import the new CSV file into the main data file each time I need new data?
Any suggestions will be hugely appreciated!
Thanks)
Bookmarks