Error message help with linked worbook

M

Mifty

Hi everyone,

I've got 2 workbooks that are linked by a sumproduct function. The data
workbook is 6420kb and the calc workbook is 770kb.

When I open the calc workbook I get the following error message -

Excel cannot complete this task with available resources. Choose less data
or close other applications.

Once I click ok it opens the workbook and calculates as normal.

I don't have any other apps open and no volatile funcs.

Can anyone expalin please.

Also when I'm using two workbooks like this should I open the data wkbk
before opening the calc one or does it not matter

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Excel - different figures returned?! 0
Linked Workbooks - adding lines and keeping links 0
Excel 2003 -insufficient Resources 1
Ignoring a runtime error 1
linked spreadsheets in documentum 0
2007 Update links does not send message when workbook not calculat 0
linked formulas 1

Top