A HYPERLINK bug?

Copper Contributor

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 Excel 365 it always takes me to A1, in Excel on the Web it works fine. A bug? 

1 Reply

@LazloP 

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.