Results 1 to 2 of 2

Thread: Linking 2000+ cells to another spreadsheet

  1. #1

    Linking 2000+ cells to another spreadsheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have created a spreadsheet that performs calculations using data fromanother spreadsheet. It worked fine inthe past when I only needed to link around 50 cells to another spreadsheet.

    Now, I have linked 3000 - 4000 cellsto another spreadsheet so each time when I open it, it takes several minutes tocalculate / update all links.

    Is there a more efficient way to link a few thousand of cells to another spreadsheetin order to retrieve data on a daily basis?

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Wow... that sounds like a terrifying situation to me...

    Is the original spreadsheet being treated like a database? If your cells were all in a table in the source file, you could pull them in using a PivotTable. I'm fairly certain that would be quicker...
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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