PPRuNe Forums - View Single Post - Excel hyperlink file paths changed after IT 'upgrade'
Old 21st Apr 2019, 17:20
  #7 (permalink)  
Asturias56
 
Join Date: Oct 2018
Location: Ferrara
Posts: 8,469
Received 364 Likes on 213 Posts
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