Managing huge data base
 

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

Managing huge data base
 

On 1 aug, 16:28, Mario DÃ*az <Mario
wrote:
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?

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.