Excel Links issue

Anonymous
2024-02-29T15:43:02+00:00

I have a Worksheet with links that point to Sheets in the current Workbook, as well I have links that point to folders that are subfolders of the folder this document resides in.

Excel is changing the links to the subfolders.when I close and reopen Excel and they don't work anymore.

Original link: Effects\Lovell

Changed link: C:\Users\fbcar\AppData\Roaming\Microsoft\Excel\Effects\Lovell

I read that if I go into File | Info |Show All Properties| Hyperlink Base and put in the Base as the Folder and Drive my document is stored in (R:\Stuff) this should fix this problem. Which it does.

But when it does all the links to the Documents sheets break and point to a non-existent folders instead of the sheet.

How do I fix this.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2024-02-29T16:58:00+00:00

You can try the solution at this link.

Why do my hyperlinks in Excel change to a mobile folder? - Super user

  1. In Excel, open the File menu and select the options
  2. In the Options, select 'Advanced'. Scroll down to the general section
  3. Select the 'Web Options' button
  4. In the Web Options dialog box, select the 'Files' tab
  5. Deselect 'Update Links on Save'

Image

Was this answer helpful?

5 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-01T13:21:38+00:00

    Thanks. That worked. Now to fix about 1900 links...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments