Go Back  PPRuNe Forums > Misc. Forums > Computer/Internet Issues & Troubleshooting
Reload this Page >

Excel hyperlink file paths changed after IT 'upgrade'

Computer/Internet Issues & Troubleshooting Anyone with questions about the terribly complex world of computers or the internet should try here. NOT FOR REPORTING ISSUES WITH PPRuNe FORUMS! Please use the subforum "PPRuNe Problems or Queries."

Excel hyperlink file paths changed after IT 'upgrade'

Old 17th Apr 2019, 12:42
  #1 (permalink)  
Thread Starter
Join Date: Aug 2007
Location: Suffolk
Age: 66
Posts: 277
Excel hyperlink file paths changed after IT 'upgrade'

Gone round in circles trying to recover this, rather than manually correct a few hundred hyperlinks in an excel workbook.

I saved an excel workbook last night and then, on logging into a company laptop this morning, I had a mandatory software upgrade. After that, most of my hyperlinks had a new path added e.g. changed from Workbook%20One.xlsm#'Index 2'!A1 to ..\..\AppData\Roaming\Microsoft\Excel\Workbook%20One.xlsm#'I ndex 2'!A1

Which means that they don't work. I've tried a couple of macros I found and Kutools for Excel. Didn't work. Our IT support were useless.

Any fixes and how can I prevent this happening again?

rusty sparrow is offline  
Old 17th Apr 2019, 19:12
  #2 (permalink)  
Join Date: Aug 2010
Location: sussex
Posts: 66
Out of interest - do you use Avast and do your outlook hyperlinks in emails work?
42go is offline  
Old 18th Apr 2019, 07:52
  #3 (permalink)  
Thread Starter
Join Date: Aug 2007
Location: Suffolk
Age: 66
Posts: 277
Originally Posted by 42go View Post
Out of interest - do you use Avast and do your outlook hyperlinks in emails work?
Never used Avast and don't have trouble with email hyperlinks - only this case which must have affected others of the several thousand work for this company whose IT support is in India. Got up very early and manually amended the links and saved backup copies!
rusty sparrow is offline  
Old 18th Apr 2019, 08:30
  #4 (permalink)  
Join Date: Mar 2002
Location: near an airplane
Posts: 1,707
I can't help you with preventing this from happening again, but as for how to fix it, I would write a small macro that does a 'find and replace' on the hyperlinks. If all the hyperlinks start with the same 'WorkbookABCD" string, then you can run a search for that bit of text within the complete string and remove everything before it.
Jhieminga is offline  
Old 18th Apr 2019, 10:06
  #5 (permalink)  
Join Date: Nov 2015
Location: Farnham, Surrey
Posts: 1,284
It's a known issue which relates to how auto-recover operates with a mapped network drive. You will find it discussed in detail in This Thread together with some solutions/work-arounds. The best workaround would seem to be the one mentioned in the last few posts.

PDR1 is offline  
Old 19th Apr 2019, 19:01
  #6 (permalink)  
Join Date: Jun 2002
Location: CYYC (Calgary)
Posts: 5,392
Based on several bitter experiences in the past, I never link Excel workbooks by hyperlinks. The drawbacks outweigh the perceived benefits.
India Four Two is offline  
Old 21st Apr 2019, 17:20
  #7 (permalink)  
Join Date: Oct 2018
Location: Ferrara
Posts: 1,953
Linking ANY Spreadsheet is dangerous even when you retain complete control of them - in a shared environment they can be literally lethal.

Someone decides to make a small, simple, change and (say) copies something and then pastes it AS VALUES rather than as a formula..... and it may be years before it shows up.....

I was always taught to occasionally change an input (say product price ) to something really crazy - and see what came out..... sometimes nothing changes very much - which is worrying.

And of course there was the business of opening T5 at LHR when none of the staff could get into the Car Park as their ID's didn't match their cars in the data base. In the run-up to opening they kept amending the list in EXCEL, adding people and removing them ... and then they re-sorted into Alphabetical order - but only the NAMES column - not the ID Column............ several times.........
Asturias56 is offline  
Old 30th Apr 2019, 07:18
  #8 (permalink)  
Thread Starter
Join Date: Aug 2007
Location: Suffolk
Age: 66
Posts: 277
Thanks for all the helpful comments. The hyperlinks are mainly to pages in the workbook so relative addresses are what I would like to use, but I can't find that as an option.

I'll just make sure to close any excel workbooks and have backups on the cloud. I only have to use this worksheet until June when I thankfully retire!
rusty sparrow is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.