Forum Discussion
A HYPERLINK bug?
This simple code works as intended in Excel on the Web, but doesn't in Excel 365: =HYPERLINK("#A"&{1, 2, 3, 4, 5}) It should create an array of hyperlinks that take me to A1, A2,..., A5. In...
Bug or that's by design I'm not sure. But yes, it's desirably to have identical functionality on different platforms. You may send a frown from Help->Feedback->Report a problem.