Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
Hi: Can any one please tell me how do i create a pivot table on
external data like Access table? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
Anna
Take the normal route to set-up a pivot table but select external data source on the first screen of the wizard. This then sets up a dialog in which you can select get data..., select MS Access Database from the choose data source dialog. Select the database and then the table/query. This will then offer you sort and filter options and you will be back to the PT plan where you can drag and drop data into Rows fields, column fields, values or page fields. Remember, providing you keep the unique rows in the PT below 16k the data used behind in this summary can be much larger. I regularly use data over 500k rows. You might take a look here http://www.nickhodge.co.uk/gui/datam...ablereport.htm http://www.nickhodge.co.uk/gui/datam...rtexternal.htm http://www.nickhodge.co.uk/gui/datam...taexamples.htm Not specific, just some reading around data and PTs Debra also has some great stuff at www.contextures.com -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Anna" wrote in message ps.com... Hi: Can any one please tell me how do i create a pivot table on external data like Access table? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |