MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking workbooks?(insane)

Posted by shawn on January 07, 2002 11:57 AM

I am trying to link 65 workbooks to end up in one summary workbook. I want to add the values of my total individual workbooks to this summary. When I try to use a simple formula to add these cells together I run out of room (formula to long error) Am I doing this the hard way or is there a trick to this?
Thanks so much for the help

Posted by Scott on January 07, 2002 12:13 PM

Are you just running a simple formula (ex. =Workbook1.xls]Sheet1!$A$1+'[Workbook2.xls]Sheet1!$A$1)?? I didn't think there was a limit on this. If so, then my only suggestion would be to create two subtotal workbooks that add up half each, and then the total that would add up the two subtotal workbooks.

Posted by Tim Francis-Wright on January 07, 2002 12:23 PM

Formulas cannot have over 1024 characters in them
(constants, for some reason can be 32 times longer). Go figure.

You might want to bring the data into your summary book by having the data come directly into discrete cells, then using the SUM or whatever function on the linked data. You can use a different sheet for each workbook if that floats your boat--but the limit on worksheets in a workbook is 255.


Posted by Loren on January 07, 2002 1:09 PM

Re: Linking: Name your sheets a,b,c, etc. (NT)