 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Pivot Table - Select New Database Source
Hello, We have a report that is based on a pivot table that is linked to a MS Access database. This database is located in a drive in our network drvie that stopped working. We do have a backup of the database but will restore it in some other location. Is there a less painful way to point the pivot table source database to another database than to recreate them? Thank you in advance. Brigham Hi Brig Right click on the PT and select Wizard>Back>Enter source of new data>Finish>Refresh  SignatureRegards Roger Govier > Hello, > [quoted text clipped - 11 lines] > > Brigham Thank you very much for your reply. I tried that but it only gives me an option to change within the database and not the path of the file. Brig > Hi Brig > [quoted text clipped - 16 lines] >> >> Brigham Ron Coderre has a pivot table add-in that lets you view and edit the connection string and command text, so you can change the source, in Excel 2002 or Excel 2003: http://www.contextures.com/xlPivotPlay01.html > Thank you very much for your reply. > [quoted text clipped - 23 lines] >>> >>>Brigham SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html This is great. Thank you very much for all your help. Brig > Ron Coderre has a pivot table add-in that lets you view and edit the > connection string and command text, so you can change the source, in Excel [quoted text clipped - 29 lines] >>>> >>>>Brigham You're welcome! Thanks for letting me know that it helped. > This is great. > [quoted text clipped - 35 lines] >>>>> >>>>>Brigham SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.