Sep 25 2024 01:16 AM
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?
Sep 25 2024 04:05 AM
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.