I have Excel Workbook that has links to other workbooks and when I open it I tell it to update the data every time it asks for the location of an old workbook that it is no longer linked to.
users/tgreene2856/Document/SWA/Ranking.xlsx. When I search for this in the workbook it finds nothing...