Linked Spreadsheet Error Message

Hi

I have a spreadsheet that has links to about 10 other spreadsheets. When I try and save the file I get 2 error messages.

1) Excel cannot complete this task with the available resourses. Choose less data or close other applications.

2) Unable to save external link values

Even though I get these messages the file seems to save ok. However, it is getting a bit annoying!

Has anyone seen these messages before or know what the cause of them is?

ps. I have an On_Open macro on the spreadsheet that opens all the linked files.

Originally Posted by blatham

Hi

I have a spreadsheet that has links to about 10 other spreadsheets. When I try and save the file I get 2 error messages.

1) Excel cannot complete this task with the available resourses. Choose less data or close other applications.

2) Unable to save external link values

Even though I get these messages the file seems to save ok. However, it is getting a bit annoying!

Has anyone seen these messages before or know what the cause of them is?

ps. I have an On_Open macro on the spreadsheet that opens all the linked files.

these message prompt when there is large data in opened files.
you can avoid this by opening each file in seperate Excel Main window.

following link may help you understand this problem.

http://www.decisionmodels.com/memlimitsc.htm