+ Reply to Thread
Results 1 to 3 of 3

Pulling lots of data from multiple files is killing proccesing time

  1. #1
    Registered User
    Join Date
    10-14-2017
    Location
    Detroit, USA
    MS-Off Ver
    2013
    Posts
    7

    Pulling lots of data from multiple files is killing proccesing time

    I have to sort and keep a lot of data up-to-date for a specific excel file. I setup a slew of index/match commands referencing two other spreadsheets so that I could have a continously updated file to keep my data accurate.
    It worked great for my test page because of the limited amount of cells... But when I applied it to the actual file it takes an eternity for excel to do anything! I understand its a huge array and that's why but there has to be a way to do this.
    Is there a way for excel to even take all the data I collected from the files and print it to a spreadsheet where there are just values in the cells and not something it has to compute/reference. I'd be happy to copy and paste the whole spreadsheet if that's what it takes.
    I don't need to access this file on the daily, but everything is very dynamic and there's no way I'm updating a 18000x250 array manually.

    Any ideas or suggestions are highly welcomed and extremely appreciated

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Pulling lots of data from multiple files is killing proccesing time

    You could turn calculation off until you complete the update, then turn it back on. But be sure that does not cause problems in doing the updates, where an update of one cell might rely on the update of another cell.

  3. #3
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Pulling lots of data from multiple files is killing proccesing time

    Difficult to help without examining your workbook and formulas, but my number 1 suggestion : avoid full-column references.

    To attach a workbook:
    Click Edit Post (or just start a new reply.)
    Click Go Advanced
    Scroll down to Manage Attachments and click.
    Now just Browse for your file, then click Upload. Simple!
    Last edited by leelnich; 10-14-2017 at 11:43 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pulling data from multiple excel files
    By sstocki in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-05-2014, 03:21 AM
  2. Replies: 2
    Last Post: 10-13-2014, 01:02 PM
  3. Pulling data from multiple excel files
    By amjud in forum Excel General
    Replies: 3
    Last Post: 06-07-2013, 09:48 AM
  4. Replies: 7
    Last Post: 03-09-2012, 01:29 AM
  5. Transfering files from lots of files to one single Exel master file.
    By yjacob in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-01-2009, 11:37 AM
  6. Pulling data from multiple files into holding file
    By Darkfish in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2009, 10:13 AM
  7. pulling data from multiple files without copy/paste
    By redneck joe in forum Excel General
    Replies: 5
    Last Post: 09-25-2007, 09:04 PM

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