Is there a way to restore local file hyperlinks in excel after auto-recovery in a spreadsheet?

EMVT 20 Reputation points
2023-12-07T14:12:25.23+00:00

Is there a way to restore local file hyperlinks in excel after auto-recovery in a spreadsheet?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,165 questions
0 comments No comments
{count} votes

Accepted answer
  1. Jiajing Hua-MFST 14,655 Reputation points Microsoft Vendor
    2023-12-08T02:55:23.7266667+00:00

    Hi @EMVT

    Are all hyperlinks pointed to %Appdata%\Microsoft\Excel?

    Currently, I find a workaround is using vba macro to change the hyperlink path back.

    For more about the macro, you may check whether the thread 'How to Find and Replace Hyperlink Addresses in Excel' is helpful.

    Thanks for your understandings.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.