Out of curiosity I did an example in Excel 2003 same things happens! So not a bug then. Suggest you make a single cell name range just above or next to the range you want and hyperlink to that.
Hands-on: Acer Predator Triton 700 review
D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year
How to lose weight with an Apple Watch
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.