Post a copy of your formula, then someone might be able to suggest
improvements or ways around the limitations.

Pete

monkey1 wrote:
I am trying to link to several workbooks elsewhere on my computer, each book
has one sheet per month and a total sheet, the sheet i am working on will
contain all the same sheets but i want it to add up each month from the other
sheets so i get a total for each month and a total of everything all together.
When i try to put the formula in i get an error saying 'the formula is too
long' Is there any other way of linking to them, or making the formula
allowed larger