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