Thread: Excel Cubes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Smoot Steve Smoot is offline
external usenet poster
 
Posts: 1
Default Excel Cubes

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.