Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path name problem with pivot data source
Thanks Dave
Typing the UNC and full patname when linking the pivot table fixes the problem (I didn't need to disconnect my mapped drive) I did have to build my excel file again though - could not find a way to edit the 'problem' pathname in the original file? "Dave Peterson" wrote: First, this is untested and from memory. So you'll want to test it yourself. When I had to do this, I found that I had the best luck by disconnecting that mapped drive. Then I'd use the UNC path when I created the link/pivottable... I don't recall any problem when the user opened it. But I have read posts where if the user saved the file, the link would convert to the mapped drive. I don't recall seeing this problem, but I did my best to make sure that important drives were always mapped to the same letter for each user. David wrote: I have a situation with many users mapped to the same server under various 'drive letters' Lets say the server name is 'abcd\'. when users map to network drive they may get 'X:\' or 'Y:\' or 'Z:\'. They will see adcd\MyDatabasefolder:\.. as Z:\MyDatabaseFolder\.. etc. I need to force 'abcd\MyDatabaseFolder\' as the pathname when setting up the data source for the pivot table so that all users can refresh the pivot table via a valid path regardless of which drive letter has been aloocated on their machine. I suspect there is a convention for naming the path that I am not aware of. I've tried the obvious, but no luck so far Any ideas? -- Dave Peterson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path name problem with pivot data source
I'd rebuild. But I still don't have a way to test to see if there's something
easier. But I would verify that it worked on the other pc's (if you haven't already). David wrote: Thanks Dave Typing the UNC and full patname when linking the pivot table fixes the problem (I didn't need to disconnect my mapped drive) I did have to build my excel file again though - could not find a way to edit the 'problem' pathname in the original file? "Dave Peterson" wrote: First, this is untested and from memory. So you'll want to test it yourself. When I had to do this, I found that I had the best luck by disconnecting that mapped drive. Then I'd use the UNC path when I created the link/pivottable... I don't recall any problem when the user opened it. But I have read posts where if the user saved the file, the link would convert to the mapped drive. I don't recall seeing this problem, but I did my best to make sure that important drives were always mapped to the same letter for each user. David wrote: I have a situation with many users mapped to the same server under various 'drive letters' Lets say the server name is 'abcd\'. when users map to network drive they may get 'X:\' or 'Y:\' or 'Z:\'. They will see adcd\MyDatabasefolder:\.. as Z:\MyDatabaseFolder\.. etc. I need to force 'abcd\MyDatabaseFolder\' as the pathname when setting up the data source for the pivot table so that all users can refresh the pivot table via a valid path regardless of which drive letter has been aloocated on their machine. I suspect there is a convention for naming the path that I am not aware of. I've tried the obvious, but no luck so far Any ideas? -- Dave Peterson -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path name problem with pivot data source
ps.
You could open the pivottable wizard for that pivottable and hit the back button a few times, change the source and then finish (or go forward), though. Dave Peterson wrote: I'd rebuild. But I still don't have a way to test to see if there's something easier. But I would verify that it worked on the other pc's (if you haven't already). David wrote: Thanks Dave Typing the UNC and full patname when linking the pivot table fixes the problem (I didn't need to disconnect my mapped drive) I did have to build my excel file again though - could not find a way to edit the 'problem' pathname in the original file? "Dave Peterson" wrote: First, this is untested and from memory. So you'll want to test it yourself. When I had to do this, I found that I had the best luck by disconnecting that mapped drive. Then I'd use the UNC path when I created the link/pivottable... I don't recall any problem when the user opened it. But I have read posts where if the user saved the file, the link would convert to the mapped drive. I don't recall seeing this problem, but I did my best to make sure that important drives were always mapped to the same letter for each user. David wrote: I have a situation with many users mapped to the same server under various 'drive letters' Lets say the server name is 'abcd\'. when users map to network drive they may get 'X:\' or 'Y:\' or 'Z:\'. They will see adcd\MyDatabasefolder:\.. as Z:\MyDatabaseFolder\.. etc. I need to force 'abcd\MyDatabaseFolder\' as the pathname when setting up the data source for the pivot table so that all users can refresh the pivot table via a valid path regardless of which drive letter has been aloocated on their machine. I suspect there is a convention for naming the path that I am not aware of. I've tried the obvious, but no luck so far Any ideas? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Source Data File Path Change | Excel Discussion (Misc queries) | |||
Date problem in Pivot Tables when using SQL as a Data Source. | Excel Programming | |||
Q: Change pivot table source path? | Excel Discussion (Misc queries) | |||
Can't change source data path for Pivot Chart | Charts and Charting in Excel | |||
Pivot Table - Data Source problem | Excel Worksheet Functions |