HELP-Hyperlink point to wrong directory after crash

B

bfranrmts

New Member
Joined
May 12, 2008
Messages
1
I have an excel file with hyperlinks that point to the network directory. After a crash MS-Excel offered to re-store the excel file saved just before the crash. I did that and now all the hyperlinks point to the local /Documents & setting/ user directory
How can I restore all the hyperlinks to the correct destination.

I tried with 'replace' but that did not work. HELP.

Thanks.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
Has there been a response to this question?
I had the same thing happen to me: Computer turned off with files open, I recovered the Autosave file and the hyperlinks I had were redirected to my local drive.
Is there a simple fix for this?

Thanks

Miguel
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
Excel Crashes when I Save Any File
Replies
4
Views
222
nolass
N
E
  • Question
hyperlinks path changes without notice in a excel workbook
Replies
3
Views
255
jkpieterse
jkpieterse
G
  • Solved
Change Macro to import files from hyperlinks
2
Replies
12
Views
451
GarnesGambit
G
E
  • Question
Old XLSM files crashing Excel; looking for help to troubleshoot, please
Replies
9
Views
1K
jkpieterse
jkpieterse
Knockoutpie
  • Solved
VBA Save Personal.XLSB to second file path if first file path is not available
Replies
3
Views
282
rollis13
rollis13

Forum statistics

Threads
1,215,267
Messages
6,123,964
Members
449,137
Latest member
yeti1016

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top