Hi,

I have an Excel file (2010) that includes hyperlinks to other Excel files and its been working as expected. However, the files I have been linking to lately have not been working. I click on the link, which is the correct link, the hourglass shows up for a while and then nothing happens. If I click back into the spreadsheet the hourglass goes away. It turns out that after some testing, it's because I've started to link to .xlsm files and it doesn't like it. I resaved the master file as a .xlsm in case it was offended at having to open macro enabled files, but it didn't help. I've tried playing with the settings in the Trust Centre, to all the none recommended settings that let anything run, but it didn't help.

I'm now stuck and really need to get this to work. It's not really feasible to change all the 'sub files' from .xlsm to .xlsx, which I have tried and does make the link work again. So I don't want to have to do that.

Any ideas please?

Thanks!

Michelle