determining the data source

H

Henry

Hi,

I have some excel pivot tables written by someone else and I want to
know where it's getting the data. Is there any way to figure that out?
I need to determine which Access database, what tables, and what
values from the table/s. Thanks.

Henry
 
P

Paul Lautman

Henry said:
Hi,

I have some excel pivot tables written by someone else and I want to
know where it's getting the data. Is there any way to figure that
out? I need to determine which Access database, what tables, and what
values from the table/s. Thanks.

Henry
Click to expand...

Open up the wizard for the table and click the Back button
 
H

Henry

I tried that but it still doesn't show the source of the data. There
is a button for "Get Data" and nothing else. When I click the button,
I get an error message saying the query cannot be edited and just
hangs.
 
Top