How can I find the data source ??

M

MVP - WannaB

Hi, and Thank you for any help.
I have in hertidted a hand full of Pivot table spreadsheets that Pull data
in from an Access DB, and the query used in the spread sheet needs to be
modified (it is using some Dates that shoudl not be hard coded). There are a
few that I just can not find any Links, or Data Queries, nothing that looks
like it is calling out to the data source, except it does prompt me to
refresh the data when I open the file. I've found all the hidden sheets, and
named ranges (I think) I've looked through all the VBA also.
How do I find what I can't see??
Thanks...
 

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

How can I find the data source ?? 0
How to find the data source 3
Active Content in this file is blocked issue 1
How do I clear a form? 0
Power Pivot Question - Adding a column from the Source Table 1
excel external data range "failed to refresh" 0
reference is not valid message for pivot tables based on Access query 4
How can I find paragraph breaks that are not preceded by a period? 0

Top