Windows 10: Office Programs cannot access network drive

I have a pc with a mapped network drive. Office programs will not access the drive directly. If I use excel to open an excel file on the network, I get a permissions error. However, if I browse to the drive with windows explorer, I can double click the file and it opens. The user is running Office 2019.

:)

 

Home network

Did you try this

Just a stab in the dark really...

 

Unable to access Network drive

Hi,

Thank you for writing to Microsoft Community Forums.

• Since when are you facing this issue?
  
• What is the version of Windows 10 installed on the computer?
  
• What is the exact error message you’re getting while trying to access the network drive?
  
• Are you able to access the drive using its IP address?
  

I suggest to follow the steps posted by Pauli O and see if it works.

How to get network sharing work with Windows 10

Please get back to us with the information requested above, so that we can suggest the appropriate troubleshooting steps.

If the issue persists, it would be more helpful for us to identify the root cause of the issue, if you can post the screenshot of the error message/code you are getting.

How to include a screenshot in your post

We look forward for your reply.

Peer Samie

Microsoft Community-Moderator

 

Cannot access shared network drive


Personally, I wouldnt use Everyone. If anyone hacks into you, they have full access to everything and can demolish everything on your raid. I would rather set up accounts and access separately for each person. That way, I know who did all that damage. In the end with a little extra work, I feel more secure by using Authenticated Users.


If this helps.
step 1 create non-microsoft account and without email and address without admin rights
step 2 share a drive or folder to specific user account (if Everyone is listed, remove it)
step 3 set security > add Authenticated Users (if more than 1 account) or add specific users
step 3a remove Everyone from list
step 3b uncheck full control and write for all items listed except SYSTEM and Admin account.
step 4 right click Start > Computer Management > System Tools > Shared Folders > Shares ... to verify settings and change anything else. You can also see the number of connections to each share here.