Open excel pivot source data in Access?

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

Guest

I have an Excel (2003) pivot table based on an Access table. Is there a way
to open the 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
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
 
Back
Top