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? 

​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?   Read More

​