Error Message - Unable To Determine Why

[Gtrtim112]

I'm getting an error in when I pull data into my Excel file and I cannot figure out how to get rid of it. The spreadsheet works fine. This error message pops up multiple times while pulling in the data, though. I cannot attach the original file. It's way too large. Basically, though, it connects to an iSeries system and pulls in a bunch of data that pertains to operational metrics. Typically, when something like this happens, I can break the link if not needed. In this case, though, there is nothing listed for this in the connections. Another oddity about it is that the error does not occur when using Excel 2010 but it does when using Excel 2013 and Excel 2016. Weird!

Any ideas?

error.png

[sweep]

Hi,

I use a link finder add-in that's available here: https://www.manville.org.uk/software/findlink.htm

[Gtrtim112]

Hi,

I use a link finder add-in that's available here: https://www.manville.org.uk/software/findlink.htm

Wow... that actually worked! I didn't think it would because I don't get the "Update Links" message when I open the file. I gave it a whirl anyways and sure enough, it found an old PIVOT table buried in the file (this workbook has about 30 tabs that are mostly hidden). That old PIVOT was trying to connect to some random file. It probably stems from a version of the workbook that we used years ago.

Anyways... thanks so much!