Available resources

[Raju]

Hi all,
I have a problem saving a xl file. The file which I am trying to save is
about 2.35mb and has external links. When I try to save it a error pops up
1.Excel cannot complete this tast with available resources. Choose less data
or close other application.
2. Unable to save external link values.

Thanks
raju

 

[Graham Whitehead]

Hi,

I have experience this problem in the past when using a sheet with lots of
code and user input buttons and drop down buttons etc. What was happing was
that excel was reading through the code and running sub routines from drop
down boxes and creating a recursive loop. If you have these type of
controls in your excel then check the activation events for the routines
which are activated by them.

Hope it helps