A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hello @Clayton Porter
This does sound worth reporting, especially if the hyperlink target is correct but Excel highlights/navigates to the wrong location.
Before reporting it, test the workbook in Excel Safe Mode and create a small test workbook with the same type of direct cell hyperlinks. That will help determine whether the behavior is workbook-size specific or an Excel rendering/navigation issue.
Microsoft confirms that hyperlinks can target specific cells directly, so named ranges aren't required.
If it reproduces consistently, use Excel → Help → Feedback (or File → Feedback) and include a sample workbook, Excel version/build, expected versus actual target, and screenshots. Feedback submitted there goes directly to the appropriate Microsoft 365 product team.
Help make this community better for everyone: if this answer resolved your issue, please accept it or upvote it. If not, share more details in a comment so we can continue the discussion and find the right solution.