B
BlockNinja
Not sure whether this should go in Excel Programming or Access Programming...
I've been working on a set of utilities in Access to do different things,
like analyzing queries in an access database that you choose to see where
their source tables are, which I've got mostly working. I've been asked to
write up some code to check an Excel spreadsheet to see where all of the
hidden links, pivot table links, chart links, etc are that reference another
workbook. Any ideas? I have it go through all of the cells right now that
it sees to look for any outside refs in the regular cells.
I've been working on a set of utilities in Access to do different things,
like analyzing queries in an access database that you choose to see where
their source tables are, which I've got mostly working. I've been asked to
write up some code to check an Excel spreadsheet to see where all of the
hidden links, pivot table links, chart links, etc are that reference another
workbook. Any ideas? I have it go through all of the cells right now that
it sees to look for any outside refs in the regular cells.