About Us

peyman

thanx Don,
I'm gonna send you the files.

"Don Guillett" wrote:

Why are you shouting at me??? If you are, INDEED, using the whole column,
change to the area concerned to see if it makes a difference.

If desired, send your file to my address below and I'll take a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"peyman" wrote in message
...
THE FORMULA IS WORKING WELL AND I HAD NO PROBLEM WITH THAT BEFORE!

"Don Guillett" wrote:

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Peculiar External Link Problem	Ananth	Excel Discussion (Misc queries)	1	April 3rd 09 07:53 AM
External Link Problem	Matt	Excel Discussion (Misc queries)	0	March 21st 08 03:50 PM
External Link Problem	Beth S	Excel Discussion (Misc queries)	2	March 28th 07 01:51 AM
FInding external link	Fred Smith	Excel Discussion (Misc queries)	1	August 31st 05 02:54 AM
External link	KIS	Excel Worksheet Functions	1	May 28th 05 12:36 PM

Menu

About Us