Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Redirect source of pivot table
Client inherited some files with pivot tables that are pulling data from an
Access database. The access database was moved to a different drive so when she tries to refresh the database, she gets an error that the file can not be found. We have tried to redirect it to the correct location by browsing and selecting the file but we then get a dialog box asking for the administrator password. If we leave the pasword field blank, we then get a message that query can not be edited with MS Query. She is able to open the database and is not prompted for any passwords. How can we redirect the pivot table to the new location of the database? -- maryj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Q: Change pivot table source path? | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions |