Re: Formula Too Long

Giganews Newsgroups
Subject: Re: Formula Too Long
Posted by:  Dave Peterson (ec357…
Date: Fri, 10 Oct 2003

Maybe you could shorten the path (move the files) and choose shorter folder

But I think I might use 14 different cells (on a hidden worksheet????) and just
write a formula like =sum(ThatHelperRangeOnThatHiddenSheet)

(it might be easier to update when you add the 15th, 16th....

Todd wrote:
> Is there anyway to expand the amount of characters that a
> formula will allow?  I am trying to link 14 different
> spreadsheets to one and I keep getting the formula is too
> long error.  Any help will be appreciated.  Thanks in
> advance.
> Todd


Dave Peterson



In response to

Formula Too Long posted by Todd on Fri, 10 Oct 2003