excel update links

Posted on 2012-09-18
Last Modified: 2012-09-26
We are having an iussue where an excel workbook has a lot of VLOOKUP links to another workbook in order to fill in various fields, and the update process can take a long time. If we try to change the source or update the source it again takes a very long time. Sometimes it does not even manage to finish
The VLOOKUP scripts are in one column on each of 253 worksheets and occupy around 20 rows on each worksheet
The excel version is 2003
Both The linked workbook and reference workbook are on the network

Is the slow response due to the number of worksheets with the VLOOKUP scripts or is it a network issue
Question by:doctorbill
    LVL 18

    Accepted Solution

    You are working near the upper limit of a 2003 workbook (255 worksheets).   The performance can be due to memory limitations (what is your O/S? , installed memory?) or network (what is your data speed?  10, 100, 1000 mbits?)
    How many pages are used in the vlookup reference workbook?   If it one worksheet, can you copy it into the existing workbook to eliminate the link and reduce the memory requirement?

    Have you set the workbook to manual recalculation to better control the processing requirement?   What version of Excel are you using - 2003, 2007, 2010?

    Author Closing Comment


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Excel writer in php that allows file save, NOT download 3 24
    Excel File Date Format 6 17
    Min Month2 5 16
    Check version 13 42
    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now