+ Reply to Thread
Results 1 to 4 of 4

Excel cannot complete this task with available resources

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    Boston
    MS-Off Ver
    2003 SP3
    Posts
    42

    Excel cannot complete this task with available resources

    I have a presentation spreadsheet (SS) that until recently worked fine.
    It requests the user enter a recipe by listing codes and quantities.
    By VLookup it then pulls all the relevant descriptions, costs etc from another data SS.
    The data SS has over the last year doubled in size and I now get the Excel cannot complete this task with available resources..... message unless I have the data file open first.
    Can I force the presentation SS to open a copy (preferably hidden in the background) of the data SS to prevent this or is there an alternative.
    I have minimised the amount and complexity of my formulae to try and avoid this but cannot think of an alternative method.

    Thanks

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Excel cannot complete this task with available resources

    Hello PhilSM,

    How big are the spreadsheets now? It sounds like you could benefit from restructuring the workbooks. Form what you describe, this seems to be a standard database setup. Can you post the workbooks?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    11-06-2008
    Location
    Boston
    MS-Off Ver
    2003 SP3
    Posts
    42

    Re: Excel cannot complete this task with available resources

    Thanks for reply. I've attached the two sheets, (there is a third one linked but this is a very small file with far fewer links).

    Phil

    I'm afraid I can't get either uploaded as they both exceed the 1Mb allowance and, thanks to our it department, we cannot send or receive zip files !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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