Ask Experts Questions for FREE Help !
Ask
    nikeshtnt's Avatar
    nikeshtnt Posts: 52, Reputation: 1
    Junior Member
     
    #1

    Jun 5, 2008, 05:24 AM
    Execl links
    I am working in finance and almost everything is in excel. I love using links and formulas for getting data from different files. But this creates problem also like now a days I am getting following error massage..

    "Excel cannot complete the task with the available resources. Chose less data or close other applications."

    After clicking OK

    Another massage comes is

    "Unable to save external link values."

    But if I close the file and do the same as above and reopen that file it appears as saved till the last when closed down.

    Now I can't make out that if there is any problem in this or some problem is going to come.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Jun 5, 2008, 08:50 AM
    You can overtake the plumbing with multiple external references. Although you are calling only a few cells, the system has to load the ENTIRE document into "background memory." So if the reference doc is HUGE, and you've referenced back and forth and across (the referenced doc has referenced docs and so on... ) then the amount of memory used shoots up exponentially.

    I know this may sound scary, but you need to reorder your external references. You need to have two types of docs...
    • Docs with data and no references to other docs. Try to keep these docs reasonable in size, but you can have as many as you need.
    • Docs that reference other docs. Keep the number of these documents low, but the docs can be as big as you want.

    Also, at this point I would make sure the computer you are working on has the MAX installed memory/speed available to the model.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Links [ 3 Answers ]

My computer has stopped responding when I click on a link or on a "click here for further info". I can sometimes go to the linked website by copying the link to the address line. This is a recent development as I have always been able to use all links. I'm using Win98 second addition with MS...

E-mail links [ 1 Answers ]

When I read through my e-mail, some provide links to web-sites, but when I click on them nothing happens. It used to work fine a few weeks ago. Something must have happened. Anyone know how to fix this? Thanks


View more questions Search