How do I link 12 spreadsheets without exceeding the max formula l.

[Joseph E.]

I have linked 12 spreadsheets and have received a error message that reads
"formula too long." Can this lenght be adjusted or what other work arounds
are there? I have never seen this error message before.

 

[Max]

Try this previous post by Charles Williams below
(Jul 26 2001, 7:10 am microsoft.public.excel.misc)

"max length of a formula is 1024 ( expressed in R1C1 mode), however
generally I find formulae that long very hard to
understand and debug: they are prime candidates for errors.

To shorten a formula try:
- break it into several shorter formulae
- use short sheet names
- store parts of the formulae in Names and use the names in the formula "

--

Since you're linking 12 sheets (Monthly sheets to a 'Yearly" summary ??),
you could try shortening the 12 monthly sheetnames to, for example, just
simple numbers: 1,2,3, ...12. This might help give you some welcome relief /
leeway (I'd usually do this)