I have created a couple of sharepoint lists, one that uses a lookup on the document library to link multiple documents to a list item. The other list is to create tiled links that link to documents, again in the document library.
I am using Sharepoint as part of Office 365
The problem I have is that opening the documents from these lists open in the browser instead of the client application (usually Excel), the spreadsheets are too complex for the browser based version of Excel so I need them to always open in the client application.
So far, I have set the default open option for the document library (Documents Settings > Advanced Settings) for the master site and subsite to Open in Client application by default; obviously this works for the document library, but doesn't work for the lists.
Searched for ages on this problem and either nobody has it or people that do this aren't bothered by documents opening in the browser. Would be greatful for any help on this, or if you can think of a better way to do it....