I use Excel to catalogue e-commerce data. I have a spreadsheet that has columns of product reference numbers plus usernames etc. and I use the =hyperlink function to generate links to targeted webpages. This has worked well in the past but recently my organisation introduced Outlook safe links and coincidentally the only way I can get these spreadsheets to work is by running them in Excel in a browser. The hyperlinks calculated by the function are not resolving properly in the Excel desktop App but they are okay in the online version. This is a pain and I wondered if there was a way I can force the desktop version to work in the same way as previously?
