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) 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




--
PSM