none
[Problem] Excel o365 repair ref. link to a wrong location RRS feed

  • Question

  • Background

    User upgrade from MS office 2010, 2013 to o365.

    Problem

    User has excel file containing ref. link which map to network drive example : (U drive), both original and target excel file also located by U : drive.

    When open by o365, set manual calculation, save and open again,

    excel report it find a problem within the file and ask whether user want to repair.

    After repair on U drive, we find excel map to wrong file (example F: drive….).

    User try to manual change the ref. link.

    After 1 or 2 day,

    The concerned excel report error again.

    And after repair, excel ref. to wrong file again.

    That excel is at least 50 MB and used many years,

    And many other excel at same condition need to be handled by user later,

    User cannot sure every link repaired correct.

    Question

    Please advise how could we fixing the path.

    we know excel save absolute / UNC path,

    but we fail to retrieve its mapping table.

    Also we cannot check whether the UNC path also changed by the excel repair process.

    p.s. I am new here. Please remind me if I post to wrong place and thankful if can indicate where should I post.


    Thursday, November 5, 2020 1:38 AM

Answers

All replies