xml version of Excel -- <SupBook> tag.

[bdbBear]

I have an external link in my workbook that I am trying to locate.

I saved my file as an xml file and did a search for "C:\". I did find the link in the xml file (see below). It is within a <SupBook> tag and before a list of sheet names. Does anyone know what this means regarding where this link is located?

<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice:excel">
<SupBook>
<Path>C:\Temp\Temporary Internet Files\OLK10F\BAL DEV 051110a.xls</Path>
<SheetName>SearchResults</SheetName>
<SheetName>ASData</SheetName>
<SheetName>Cover</SheetName>

Thanks,

- Bruce

 

[PHV]

what this means regarding where this link is located?
It is located in your IE cache.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bdbBear]

I know that the file itself is in the IE cache, but what I'm trying to figure out is where is the formula (what cell in what worksheet) that is referencing a cell in this file?

I've gone through each worksheet and every cell that has a value. I've looked at the different controls and their linked cells, etc., so not sure what else I can do.

Thanks,