View Single Post
  #1  
Old June 2nd, 2010, 07:16 PM posted to microsoft.public.excel.misc
PiB311
external usenet poster
 
Posts: 18
Default Pivot Table with MS Access as DataSource

Hello all. Thanks for the help in advance.

I am trying to use a UNC to pull data from a MS Access database as a
external datasource for a pivot table in MS Excel 2003. I can actively pull
the data, since I have a network drive mapped to the location, but others who
have the drive mapped to another letter are unable to open the document and
refresh.

I am trying to figure out the best way to create this pivot table utilizing
the shared network UNC. Please help!

Regards,

Me