Perhaps you are using the entire column for your formulas.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"peyman" wrote in message
...
Hi,
Does anybody know what this error message is:
" Excel can not complete this task with available resources. Choose less
data or close other applications"
I've 2 files, one as reference w/ 6000 rows data and another file linked
to
the reference file by formula( the formula is SUMPRODUCT formula and not
array or very complicated one). when I open the second file only all the
formula turn to #REF error, but when the reference file is open the
formula
work well and the answers are Okay but when saving the above Error Message
comes up.
Any help?
Thanks