Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
formula and cell link movements | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
What formula do I use to link worksheets together within one spre. | Excel Worksheet Functions |