excel data consolidation

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Data consolidation

Excel Data consolidation

resolvedResolved · Low Priority · Version 2003

John has attended:
Excel Advanced course

Excel Data consolidation

Is there a limit to the number of datasheets you can consolidate ?

RE: Excel Data consolidation

Hi John,

Thank you for your post, welcome to the forum,

To my knowledge this is open ended, its one of those questions which is answered by Microsoft by the wonderful words 'Limited by available memory', which doesnt really answer the question at all.

I hope that helps :)

regards Pete

RE: Excel Data consolidation

Thanks Pete - I'll guess I will just plough on and see when it starts to get cross. I could be OK as I don't have too many (>100)

Cheers..................John

RE: Excel Data consolidation

Thanks John, you should be alright with that number.. Pete


 

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips


Server loaded in 0.09 secs.