I was wondering if I could set up my external references to Microsoft Access using relative paths rather than absolute paths.
Basically, I'd like to be able to move my files around and have the links still work. Otherwise, I have to go to each PivotTable with external links and update the link. It's a pain.
Basically, I'd like to be able to move my files around and have the links still work. Otherwise, I have to go to each PivotTable with external links and update the link. It's a pain.