Saving 2 part question

[EOAEvan]

Part 1:
I have a very large lookup table that I have split into 4 files as it was approaching 8 megs in size and I do not need every sheet to calc evertime I update the source info. This way I will just open 2 files. 1 that contains the base data and the second file that contains the desired output sheets. Whever I save the output file I will now always get a error saying "not enough memory" and "unable to save external link values". Is it correct to assume this simply means that if i were to open this file without the source file being open it just wouldnt display the values that were there when I last saved?

Part 2:
If I am correct with my assumption in Part 1. Can anyone provide me with a way to suppress this warning as we will never need those valuse to be saved.


If this is not clear in any ways please let me know.

 

[texasalynn]

I've had those types of errors when you have vlookup formulas or something similar and those referenced files were not opened. The only way to stop those errors would be if the linked files were also opened.

HTH