Share via

Excel Error - Linked to old ShareDrive

W.J. Carson 1 Reputation point
2020-10-28T17:46:04.983+00:00

I have an end user who is using an Excel file created with their previous employer. Anytime the file is opened, it is trying to update Fomulas from that employers ShareDrives. I've removed all references to the previous employer's file shares and update formulas. The issue persists. I've attached the screenshot. Any suggestions would be greatly appreciated.

35753-screenshot-36.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,666 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,556 Reputation points
    2020-10-29T07:29:21.89+00:00

    @W.J. Carson ,

    Do you mean this Excel file could be opened but there would be the errors with linked file, such as 2000PR-White-NoV00.xls?
    Besides, how did you remove all references to the previous employer's file shares?

    • Please go to Data > Queries and Connections, check whether the "Edit Links" is available.
      If yes, click Edit Links, break the links with employer's file shares in Source list.
    • If the link used a defined name, please go to Formulas > Defined Names group > Name Manager, check whether there is the range of external reference.
    • Please also check the Conditional Formatting (Manage Rules) and Data Validation.
      If there is any references linked to those files, please remove them.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments