Pivot Tables and External Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a Pivot Table based upon external data residing in an Access
database. I wish to be able to email the Excel worksheet and the Access file
to remote users so that they can use the Pivot Table as well. However, the
Pivot Table seems to be using absolute references for locating the file, and
therefore can't find the file at "C:\Documents and Settings\etc." (where it
was on my machine)

Is there a way to have the Pivot Table just use relative locations so that
it can find the file in the same directory that the Excel worksheet is in?

Thanks for any help!
Ken
 
BrianB said:
Always keeping both files in the same folder seems to work OK no matter
where they are.
Click to expand...

That's odd... because it is certainly failing on my system. Here's what I
did:

1. I created an Excel file with a pivot table based on an Access database.
Both files were in my C:\temp directory.

2. I then moved the files to my desktop. (The files have to be moved, not
copied. Because if you copy them, the source Access file can still be found
in C:\temp.)

3. I open the Excel file from my desktop. At first the pivot table seems to
work, at least until you try to refresh the data. Then I get an error
stating that the source file C:\temp\test.mdb cannot be found.

Are you doing anything different when you first create the pivot table that
in some way indicates it is a relative location?

Thanks for the help!
Ken
 
Back
Top