Posted to microsoft.public.excel.misc

Abhay

Posts: n/a

Formula length

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a formula change a cells colour after a given length of time?	Clive Humphries	Excel Worksheet Functions	1	February 20th 06 10:23 PM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
formula to standarize cell length	JT	Excel Worksheet Functions	1	May 24th 05 09:42 PM
maximum formula length	skywalker99	Excel Worksheet Functions	2	March 1st 05 09:30 PM

All times are GMT +1. The time now is 06:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us