I have a spreadsheet that links to an Access database and creates a pivot table.
I would like to update the link to pull from a different database.
How do you do that without havig to recreate everything?
Thank you.
I have a spreadsheet that links to an Access database and creates a pivot table.
I would like to update the link to pull from a different database.
How do you do that without havig to recreate everything?
Thank you.
Here you go....
The free Pivot Play add-in, located at Debra Dalgleish's website, may help:
http://www.contextures.com/xlPivotPlay01.html
It allows you to view/edit the connection and SQL code for Pivot Tables that use external data sources. It has many other features, too.
Does that help?
It worked perfectly! Thank you very much.
This is a wonderful site. It has been tremendously helpful with my job.
You're very welcome......Thanks for the feedback.
(...and yes, this site is quite a resource)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks