Can't change pivot table's Access data source - bug in Excel 2000 SP3?
- by Ron West
I have a set of Excel 2000 SP3 worksheets that have Pivot Tables that get data from an Access 2000 SP3 database created by a contractor who left our company. Unfortunately, he did all his work on his private area on the company (Novell) network and now that he has left us, the drive spec has been deleted and is invalid.
We were able to get the…