Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Managing Data in 2 spreadsheets | Excel Discussion (Misc queries) | |||
Managing a picture folder with excel data | Excel Discussion (Misc queries) | |||
Managing Data in Cells | Excel Discussion (Misc queries) | |||
Managing bad data | Excel Discussion (Misc queries) | |||
huge huge excel file... why? | Excel Discussion (Misc queries) |