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

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 !