Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel pivot source data in Access?
I have an Excel (2003) pivot table based on an Access table. Is there a way
to open the source data in Access? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel pivot source data in Access?
To me this doesn't make sense. You P/T is based on data in Access and you
want to open it in Access. Is it not already there? If you are looking to mirror the pivot table in Access then look for a crosstab query or produce a report -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "770.wookie" wrote in message ... I have an Excel (2003) pivot table based on an Access table. Is there a way to open the source data in Access? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Open Pivot Table Source | Excel Discussion (Misc queries) | |||
excel chart with data source from an access query | Charts and Charting in Excel | |||
I NEED TO KNOW THE SOURCE OF A PIVOT TABLE FROM ACCESS in excel | Excel Discussion (Misc queries) | |||
Access Create Excel Pivot Table Data Source | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |