Posted to microsoft.public.excel.programming

Len

external usenet poster

Posts: 162

Data Consolidate Limitation

Hi,

Consolidate function is useful for budgetary consolidation purpose
However, if there are 12 worksheets to be consolidated, then
consolidate function is unable to call back and consolidate say 45
worksheets as it has reached the max limit of consolidation ( ie 12
sheets )
In this case, is there any options/alternatives available either on
excel function or excel vba to solve this problem ?

Thanks & Regards
Len

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
Excel Import - data limitation	Carmen	Excel Programming	0	September 4th 07 02:14 AM
Is there a limitation on the amount of data that can be hidden?	C Brandt	Excel Discussion (Misc queries)	5	January 11th 07 08:53 PM
consolidate data	Chi	Excel Discussion (Misc queries)	0	September 28th 06 05:12 PM
Excel Row Limitation - Import External Data	Avadivelan TCS	Excel Worksheet Functions	5	September 13th 06 04:53 PM
Data Validation Limitation	r wilcox	Excel Programming	0	February 8th 06 10:24 PM

All times are GMT +1. The time now is 11:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us