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.
Huawei P10 review
1995-2015: How technology has changed the world in 20 years
An overview: What leading creative agencies are doing to improve diversity
New iPad, iPhone SE & Red iPhone 7 on sale now
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.