Posted by Rob G on July 20, 2001 7:20 AM
I am having a problem with my pivotable source data. I have created a pivotable report on my personal space on a large corporate network. I now want others to summarize the data themselves, and for that I need to move the Access queries to a shared portion of the netwek, which changes the path of my source data in my tables. Is there a simple way of changing the path to my Access queries (just change the directories) without having to recreate the pivotables with the 'Get Data ...' feature.