Managing huge data base

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
Click to expand...

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.
 
Back
Top