S
Steve Smoot
When building a Pivot Table in Excel and creating
a "cube" from an external database (i.e., Access), Excel
builds a query file and a cube file. Since the file is
on a LAN shared drive, I would like to know how to change
the internal pointers for Excel so that the spreadsheet
can be moved from one folder to another AND so that other
users do not have to be mapped to the identical drive.
a "cube" from an external database (i.e., Access), Excel
builds a query file and a cube file. Since the file is
on a LAN shared drive, I would like to know how to change
the internal pointers for Excel so that the spreadsheet
can be moved from one folder to another AND so that other
users do not have to be mapped to the identical drive.