Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

MS Office documents opening as read-only on AFP share

With Mac OS X 10.6.6 and 10.6.5 I'm having a problem with MS Office documents opening as read-only from AFP shares. This seems to be a problem with Office 2008 and 2011.

If you create a new document in as Word and save it to an AFP share. Then quit Word and reopen the document, the document is marked as Read Only. It's not marked as Locked in the Finder. Quitting the app and opening the document again has the same problem.

If you unmount and remount the AFP the problem goes away. The problem also goes away after about 30 minutes.

Any idea what's going on?

Posted on Jan 13, 2011 9:02 PM

Reply
43 replies

May 7, 2013 10:47 AM in response to Wannes Van Loock

Found out this is due to the QuickLook Office plugin in the system.


Disabling this plugin will fix this behaviour, unfortunately you can't use QuickLook anymore for Office documents.


1. Open Terminal

2. Enter or copy this command and it will be fixed :


sudo mv /System/Library/QuickLook/Office.qlgenerator /System/Library/QuickLook/Office.qlgenerator.bak ; killall Finder

this worked!

Thank! 😀

Jul 30, 2013 3:00 AM in response to cameronkay

Try setting the permissions of the folder that contains all of the "read only" and change to "read and write" for all users ( or certain user if you olny want certain people to acces them ) and apply to "enclosed items". In my case the files were on the server the office is sharing so I change the permissions on the server so that everyone can acess the files.



here is a link in case your not familiar with the process.


http://support.apple.com/kb/PH10669


This solve the problem for me.


Good luck!!


Syms

Jan 14, 2015 5:42 AM in response to Espen Eiesland

Turning preview off (right click folder->show view options->uncheck show preview column) fixed the issue for me. I played with this a bit more and in my case, the preview is definitely what was causing the server to only allow read only. That was only happening for larger documents that took a while for the preview to load; while the preview was loading I tried to open repeatedly and kept getting "read-only", but once the preview loaded the document opened right up. Which led me to another solution for those (like me) who want to keep preview on--switch to the file list view in Finder, which doesn't have the preview pane, and documents open right up with no read-only issue.

Sep 10, 2015 8:28 AM in response to cameronkay

Several causes and fixes —


This is often due to the hidden .TemporaryItems folder at the root (top level) of a file share not having the correct permissions or not existing, or being symlinked to another storage device.


Use these commands to create the required folder and set the correct permissions on the .TemporaryItems folder


sudo mkdir /Shared\ Items/Share/.TemporaryItems

sudo chown -R 99:staff /Shared\ Items/Share/.TemporaryItems/*
sudo chmod 1777 /Shared\ Items/Share/.TemporaryItems



If this folder already exists and has stuff in it, make sure no one is connected to the server and then remove the contents of the folder. Then set the permissions correctly.


It can also be caused by the finder locking the file as it creates a preview icon or Preview pane view of the file.

This can fix that —

sudo mv /System/Library/QuickLook/Office.qlgenerator /System/Library/QuickLook/Office.qlgenerator.bak ; killall Finder



This problem can also be caused if a Users home folder is on a different drive than the main Macintosh HD and their Caches folder or items within that are symlinked elsewhere (say to /tmp or similar).


The last cause is an overlap between UIDs of users on the local machines and the server.

This can cause one user's Office to think the files are opened by the same user, but they cannot still access the files, at best. At worst, is can cause crashing as word tries to delete and reuse them files in use by another user on another machine.


You will need to check the UID of each user and compare that to the server. If there are mismatches they will need to be created. It can sometimes be enough that every one has a unique ID and there are no overlaps, but it is much better if the local UID also matches the server.

To fix this can be messy — Involving changing the UID on the server and local machine, then ensuring all the users existing files are then chown to the new UID.

Dec 3, 2015 4:10 AM in response to cameronkay

I have had this problem with a shared Excel spreadsheet on a Box cloud drive. I'm not sure what type of share it is but the solution for me was to delete the temporary file that Excel creates in the same directory as the main spreadsheet but with the file name starting with ~


Hope this helps someone as none of the other complex solutions worked in this case. Maybe because Box is a different sort of share?

Jan 4, 2016 6:50 PM in response to Wannes Van Loock

$ sudo mv /System/Library/QuickLook/Office.qlgenerator /System/Library/QuickLook/Office.qlgenerator.bak ; killall Finder



This command worked right up until OSX 10.10. With El Capitan I've found that this operation is not permitted. I see no permission differences in this file or its parent directory between Operating Systems.


Some other process other than "Finder" seems to be using it. Are you able to help?

Jan 4, 2016 8:14 PM in response to Yokoshimax

Yokoshimax wrote:


Found out this is due to the QuickLook Office plugin in the system.


Disabling this plugin will fix this behaviour, unfortunately you can't use QuickLook anymore for Office documents.


1. Open Terminal

2. Enter or copy this command and it will be fixed :


sudo mv /System/Library/QuickLook/Office.qlgenerator /System/Library/QuickLook/Office.qlgenerator.bak ; killall Finder

this worked!

Thank! 😀

To add to this, on El Capitan you may have to disable "System Integrity Protection". Link to instructions below,


http://osxdaily.com/2015/10/05/disable-rootless-system-integrity-protection-mac- os-x/

Apr 16, 2016 1:29 AM in response to Mac the Wolf

Hi everybody,

This post helped me to identify the solution as the original passthrough wasn't working anymore on El Capitan.

Effectively, since El Capitan, the Office.glgenerator file isn't accessible anymore so that you need to do the following to rename it :

1. Reboot the client workstation on recovery mode

2. Access Terminal from the recovery screen

3. Enter the following :

> csrutil disable

>CD /Volumes

>ls

This will help you identify the volume name of your workstation

> chflags norestricted /System/Library/QuickLook/Office.qlgenerator

> mv /Volumes/« volume name »/System/Library/QuickLook/Office.qlgenerator /System/Library/QuickLook/Office.qlgenerator.bak

> csrutil enable

4. Restart, it's done. You'll never be bothered again with Office files lock on your AFP/SMB shares on your Mac server.

MS Office documents opening as read-only on AFP share

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.