+ Reply to Thread
Results 1 to 1 of 1

Speeding Up Excel

  1. #1
    Registered User
    Join Date
    11-09-2006
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    200

    Speeding Up Excel

    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)
    Last edited by JBeaucaire; 02-27-2013 at 12:02 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1