Unable to save external link values.

Good morning all,

I have a problem that, from a little research, I don't think can be resolved. Due to the large number of VLOOKUP functions on my page of data whenever I try to save I get the following error codes...

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

Unable to save external link values.

The problem itself may not be solvable but is there away to prevent these messages from coming up when I save (or when it autosaves?)?

Thanks in advance for your help.

Chris.