excel queries dsn

G

gt

Hi -

I'm using Excel 2003. Many of my workbooks have pivot tables based on
external data, and I need to find out which dsn was used when those pivots
were built. I've used the pivot table wizard and looked at the query in ms
query, but haven't been able to find the dsn name. Suggestions?

Thanks,
gt
 
D

Don

it should tell you in the wizard if you use the " back ". Look at the range
and it will say the workbook / sheet / range
 
G

gt

Thanks for the post, Don.

I've used the back button and the getData button to access the query in ms
query, but there's no reference to range - the data is external (in an Access
db), and I need to know which dsn was used to create the queries.

cheers,
gt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue with being able to select 64 bit Data Sources in Excel 2007 0
Connection files and pivot tables 0
Excel / Sql Server / Pivot Tables 2
Sharing Excel 365 Mac<->PC 0
Connect a Query in MS Query top another DSN 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Failed to save table attributes of (null) into (null). 2
pivot table - show items with no data 0

Top