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
Bookmarks