Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 09-14-2010, 06:54 AM
tpcervelo tpcervelo is offline Pivot Table Refresh Windows XP Pivot Table Refresh Office 2003
Pivot Table Refresh
Join Date: Sep 2010
Posts: 5
tpcervelo is on a distinguished road
Default Pivot Table Refresh

I have a number of Excel workbooks that are set up as Pivot Tables and get their data from different Access mdb's. They all reside on one server and are created in Access 2003.
Users have a shortcut to the unc path for each...they open and refresh the data and then save it to a local location. All of this has been working for months...unfortunately a user wrote over the top of one with a blank sheet. My backup was not good so I recreated the Excel workbook. The connection properties (using PivotPlayPlus) show the correct connection unc path for the mbd...the DSN is MS Access Database which is also on their local machine (same one I have used for all of my pivots). I can open the workbook on my local machine but if I try to refresh it I get a ODBC Microsoft Access error of invalid path...instead of the unc it has a mapped drive letter. I have tried to delete and re-add the dsn but it no luck.
Does anyone know if the path is kept on the local machine?
All of the rest of my pivots refresh just fine and the connection files all are the same (obviously except for the mdb name).
Any ideas?

thanks for any help
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Refresh Adding a Total row to pivot Table hannu Excel 1 09-18-2010 01:15 AM
link comment to a pivot table dom585 Excel 0 07-15-2010 11:11 AM
pivot table source data hannu Excel 0 07-03-2010 04:54 AM
Pivot Table Refresh Pivot table problem swindon Excel 5 05-25-2010 02:05 PM
Excel pivot table into an MS Word Doc "office 2007" wmarsh3561 Excel 1 01-09-2010 08:03 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:42 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft