Insight for Excel is unable to navigate network shares created from SharePoint sites

QUESTION

Some customers use SharePoint sites to store project data, including SD files. The SharePoint site can be configured as a network drive to allow users to navigate the site and browse the stored files. For example, it works without any issues with Excel > Open. But when trying to import an SD-file with Insight for Excel using the Data From File button on the Insight ribbon, the SharePoint shortcut can be opened but it is not possible to navigate into the subfolders.

ANSWER

When the shortcut to the file location in SharePoint is initially created on the desktop, it shows up as an HTTPS address when opened from the Data From File button in Insight for Excel. If the shortcut on the desktop is edited, e.g. by adding a trailing "\" it changes to a proper "\\server.domain\...\" folder. Now the shortcut can be opened and it is possible to browse subfolders and open files without any issues.