A network file fails to open on intune laptop and says need to request SharePoint permission. On AD laptop it opens.

Question

We have a on premise network file share. Our current Domain joined laptops are able to open excel files, saved as xlsm. No issues. On our newer Intune Azure joined laptops, the user can get to the network file share and see the excel files. But then get pop up saying "ccess denied, would you like to request for permission on share pont."

If yes selected another prompt saying "opening a file at this location....xlsm can contain virusus would you like to continue"

If yes selected a further pop up giving file location (on shared file drive) and name cannot be found, reason may be

The file name or path does not exist.

file being used by another program

The workbook you are trying to save may already have same name as another workbook.

Seems to be just xlsm files. xlsx files seem to open from the same location with no issue.

Thanks for your help in advance.

Answer 1

Hi @James Gledson

Will this issue occur if you copy the .xlsm files out of the previous folder, such as to Desktop folder.

Are these .xlsm files stored on SharePoint server, and synced to local device via OneDrive?

If not, just a network file server, I suggest you following the link: https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#files-centrally-located-on-a-network-share-or-trusted-website

• Designate the location as a Trusted site

• Add the location to the Local intranet zone

Besides, please set the Network locations as a Trusted Location in Office apps. For more information, see Trusted Locations for Office files.

If yes, please refer to the link: https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#files-on-onedrive-or-sharepoint

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

Hi @james gledson

Thanks for your kind sharing.

Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.", and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

--------------------------------------------

Issue Symptom:

We have a on premise network file share. The current Domain joined laptops are able to open a on premise network shared files, saved as .xlsm. But newer Intune Azure joined laptops, the user can get to the network file share and see the excel files. But then get prompt: "Access Denied. ``` Would you like to request for permission on SharePoint?"

If Yes selected, a further pop up shown file location (on shared file drive) and name cannot be found, reason may be:

The file name or path does not exist. ```

This issue only occurs with .xlsm files, .xlsx files seem to open from the same location with no issue

Current Status:

Solved.

Two config policies on Intune that block this setting Win32 imports from Office Macro code, when a device is excluded from that policy the .xlsm can be opened.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---