| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you join multiple databases using a pivot table?
I have recently been trying to learn and use pivot tables. Is there a way to
connect 2 or more databases in a pivot table? In other words pull selected data out of 2 databases using a pivot table. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you join multiple databases using a pivot table?
You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want. There's more information he http://www.contextures.com/xlPivot08.html lbraunbe wrote: I have recently been trying to learn and use pivot tables. Is there a way to connect 2 or more databases in a pivot table? In other words pull selected data out of 2 databases using a pivot table. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
| Pivot Table - Multiple Worksheets | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
