How to speed up Excel links?
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How to speed up Excel links?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have an extremely large spreadsheet that contains links to 300 other separate spreadsheets. Obviously this takes 2-3 minutes to start up and to calculate. How can I speed this process up? (I know I can tweak the calculation setting to manual, but the links must be updated). Maybe, I'll just have to bear with it until Intel come out with a 10 GHZ chip! Any ideas would be welcome.


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    no replies, so I'll stick my oar in......

    are the 300 other files on your network ?

    if possible, pop them on your hard drive ?

    And, not exactly what you asked, but, con-incide the loading of your file with your coffee break or something so it's not lost time, per se.

    (I know Jack in the UK does this with very large files - he rearranges all his MS Word tutorials while it's loading...)

    big

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wow, 300 files... that's A LOT ! that's impossible to rearange ? reduce File count ? are all links absolutely necessary ? do you need "live" formulas ?
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Become friends with someone that knows Access.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com