Hello!,
I am consolidating data from about 35 Excel workbooks located on different
servers into a summary workbook. I have a macro to link a cell from all 35
sheets into one cell of summary book (This is sum of all cells being refred
with address).

This exceeds the formula length that Excel can support.

Can anybody suggest a workaround.

Thanks!
Abhay