How to Fix Excel Cannot Open XLSX Files on a Samba Network Drive
Question details
Standard users are unable to open Excel XLSX files stored on a Samba network share, whereas administrators can access them normally.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A standard user attempts to open an XLSX file hosted on a Samba network drive but is blocked by a file cache error.
- Observed behavior
- Excel fails to open the file and displays an error stating it cannot find a temporary file in the local INetCache Content.MSO folder.
Ensure you have the login credentials for an administrator account on your local machine, as you will need elevated privileges to modify folder permissions. It is also helpful to have the exact network path of your Samba drive ready.
Modify Permissions for the Local INetCache Folder
Since standard users cannot create temporary files in the INetCache Content.MSO folder, granting them the correct local permissions can resolve the issue.
Excel relies on the local INetCache folder to create temporary files while opening documents from a network share. If a standard user account lacks write permissions for this specific system folder, Excel will fail to open the file.
Log in with an administrator account. Press Windows + R, type '%localappdata%\Microsoft\Windows\INetCache' and press Enter to open the folder.
Right-click on the 'Content.MSO' folder (you may need to enable 'Show hidden files' in the View menu to see it) and select 'Properties'.
Go to the 'Security' tab and click 'Edit'. Select the 'Users' group and check the 'Allow' box next to 'Full control', then click 'Apply' and 'OK'.
Log out of the administrator account, log back in with the standard user account, and attempt to open the XLSX file from the Samba drive again.
Verify Samba Network Share Permissions
Ensure that the standard user group has the necessary read and write permissions on the Samba server itself.
Consult Microsoft Q&A for Server Administration
If both local and network permissions appear correct, the issue may require advanced server-side troubleshooting.
Try WPS Office for Seamless Network File Access
If Microsoft Excel continues to struggle with network drive permissions and temporary folders, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative that handles local and network spreadsheets smoothly with a familiar interface.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
- 3. Open network files easily: Launch WPS Spreadsheets, navigate to your Samba network drive, and open your XLSX files directly without permission conflicts.
Frequently Asked Questions
Why does Excel need to create temporary files in the INetCache folder?
Excel creates temporary files to prevent data loss, manage file locking, and handle auto-recovery while you are editing. If it cannot access or write to the INetCache Content.MSO folder due to permission restrictions, it fails to open the file entirely.
Can I disable temporary files in Excel to bypass this error?
No, temporary file creation is a core, unchangeable function of Microsoft Excel designed for secure editing and file integrity. You must ensure the correct folder permissions are set instead of trying to disable the feature.
Why can administrators open the Samba network files but standard users cannot?
Administrators typically have elevated system privileges that bypass restrictive local folder permissions. This allows them to write to system folders like INetCache or access restricted network shares without encountering the errors that standard users face.
How do I find my INetCache folder?
The INetCache folder is a hidden system directory usually located at C:\Users\[YourUsername]\AppData\Local\Microsoft\Windows\INetCache. To view it, you must enable the 'Show hidden files' option in the View tab of Windows File Explorer.
