View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
monkey1 monkey1 is offline
external usenet poster
 
Posts: 2
Default formula is too long

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