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

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.

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)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Joseph E." <Joseph wrote in message
...
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.