When I create piviot table reports in excel using data in an Access database. Everything works great; but when I try to distribute the excel reports My users can no longer refresh the reports.
For some reason Excel hardcodes the path to the database file, even if you use a DSN.
The excel files are always in the same folder as the Access mdb file. Is there some way to make the path to the database file, a relative path?