I have an excel file (file A) which has a few index/match functions linked to cells in another spreadsheet (file B) these functions were purely to look at and retrieve data from file B. Both files were just on the normal company network and worked fine. File B has recently been moved into Teamcenter which now means the external data links in file A are broken, and will no longer update.
What can i do to modify file A to still access file B within teamcenter? Do i need to try and find the actual location of File B (it must be saved somewhere) or is there a more simple way of pointing an excel argument towards teamcenter?