Managing huge data base

[Guest]

Hi,

I'm managing a Data base that requieres more that 65,536 rows of
information. It is possible to create Pivot Tables with data in more than one
Worksheet?

Mario

 

[Amedee Van Gasse]

Hi,

I'm managing a Data base that requieres more that 65,536 rows of
information. It is possible to create Pivot Tables with data in more thanone
Worksheet?

No, but you can use your database directly as the datasource of your
pivot table.
You can skip the step of first copying or inporting your data to a
worksheet.
Excel Help explains how to do this.
I assume your database is something that can easily be queried,
something like access or sql server or whatever.