PPRuNe Forums - View Single Post - Excel hyperlink file paths changed after IT 'upgrade'
Old 21st April 2019 | 17:20
  #6 (permalink)  
Asturias56
Community Builder
Community Influencer
 
Joined: Oct 2018
: PPL
Posts: 12,242
Likes: 1,654
From: Ferrara
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  
Reply