I have just started doing more advanced work with Excel and have run into a problem. I have a workbook (workbook A) with several worksheets. One of the worksheets contains several columns with "SUMIF" functions pulling information off of another large workbook (workbook B) with around 7000 rows. When I have Workbook A and B open at the same time and try to save either one I get the "Not Enough Memory" and "Cannot Save External Links" error messages. The solution I found on the Microsoft Support website was to uncheck the "Save External Link Values" box on the calculation tab of the options dialogue box. I did this and I no longer get the error messages - it also doesn't seem to affect the useability. I can e-mail the workbook to others and the values are ok. I can update the sheet and everything seems fine. But, I am worried that somewhere down the line I will have problems. What exactly does unchecking this box do? How does it affect the way the workbook works?
Thank you in advance for your help.
Thank you in advance for your help.
