Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message help with linked worbook
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 -- Mifty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DV message linked | Excel Discussion (Misc queries) | |||
Formula too long error message to linked spreadsheet | Links and Linking in Excel | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Increment linked worbook | Excel Discussion (Misc queries) |