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.

Can't open Office 2011 files on CIFS/SMB shares.

I can't open Excel or Word documents if they are opened from a network CIFS/SMB share. Excel returns something like "could not open because some content is unreadable" and offers to repair the document. Word just questions if the document is corrupt and errors out too. If I drag the same document to my desktop, it opens just fine. Is something broken with SMB? I'm running the latest Yosemite (10.10) upgraded from Mavericks 10.9.5. Office 2011 is completely updated too.

MacBook Pro (13-inch, Mid 2012), OS X Server

Posted on Oct 20, 2014 12:34 PM

Reply
Question marked as Best reply

Posted on Oct 22, 2014 3:13 PM

I've come across this in my workplace environment as well. You will either get an error like this:


Foo.doc uses a file type that is blocked from opening in this version.


Or


Word cannot open this document. The document might be in use, the document might not be a valid Word document, or the file name might contain invalid characters (for example, \ /).

(Foo.docx)


We would normally connect using the following:


smb://file-server.fqdn/share


We found that if you unmount your SMB connections and connected like this:


cifs://file-server.fqdn/share


We were then able to open the files without a problem.


We had this problem on NetApp c-mode file shares, however EMC VNX and Windows Server file shares didn't have this problem.


Guessing most likely this is due to a change in the SMB protocol in OS X 10.10.


As always, YMMV.

18 replies
Question marked as Best reply

Oct 22, 2014 3:13 PM in response to declure

I've come across this in my workplace environment as well. You will either get an error like this:


Foo.doc uses a file type that is blocked from opening in this version.


Or


Word cannot open this document. The document might be in use, the document might not be a valid Word document, or the file name might contain invalid characters (for example, \ /).

(Foo.docx)


We would normally connect using the following:


smb://file-server.fqdn/share


We found that if you unmount your SMB connections and connected like this:


cifs://file-server.fqdn/share


We were then able to open the files without a problem.


We had this problem on NetApp c-mode file shares, however EMC VNX and Windows Server file shares didn't have this problem.


Guessing most likely this is due to a change in the SMB protocol in OS X 10.10.


As always, YMMV.

Oct 24, 2014 3:58 PM in response to inactionhero

That's odd because my original aliases were mounted from cifs://<server>/<share>


I tried it manually though and lo and behold it worked after using Go > Connect To Server. Even more interesting is when I tried to re-create the same connection that was working as a new alias - it went back to its erroneous ways.


Look like you're right you need to manually connect with CIFS for now, but from what I can tell it ONLY works manually. Aliases seem to be broken?

Jan 26, 2015 4:18 PM in response to declure

I've had more time to play with this lately. I'm still having the issue and I've tested a few systems, new Yosemite installs, etc. I've discovered our smb server does connect at SMB3 and when you try smb://, and that causes the "file needs repair" error. If you run commands in Terminal to force an SMB1 mount, or just use the CIFS prefix, then they open - but in READ-ONLY mode. This doesn't happen in OS X Mavericks or earlier. I'm not in a position to tweak our smb server, so I tried to tweak the client first:


I've never trusted the Apple implementation of smb, so I used the older article for replacing the SMB stack in Mavericks (http://blog.helloyama.com/post/77813860132/replacing-the-os-x-10-9-mavericks-smb -stack-with) to install Samba for Yosemite. I believe I succeeded. Interestingly enough, it didn't fix anything. I'm not 100% sure I did it right, so if someone else with this issue wants to try and confirm be my guest.


Upon suggestion from an Apple purist 😉, I tried opening from the smb share with Numbers instead. Works great. I was able to export an xlsx file and overwrite the original excel spreadsheet. Still doesn't open in Office 2011 for mac, but it's something in a pinch....


The fact that replacing the smb stack changed nothing, combined with the fact that certain users with certain smb servers running aren't having problems, leads me to conclude the problem isn't Apple, but that Office 2011 still has a Yosemite bug that's going largely unnoticed for some, but not for everyone. A bug that changes the way it communicates with some SMB servers in Yosemite, but not all of them.


I don't know what I can suggest to our server admin to fix the issue, and if I suggest the idea that Office 2011 seems to be the focal point of the problem, I'm sure they'll opt to change nothing and blame Office 2011.


If anyone has a suggestion that might fix or fool Office 2011 to behaving, I'd love to try it. Probably I'm looking at waiting for a Microsoft update I'll be lucky if I ever see, or the next generation of Office for Mac apps as Office 365 moves forward. Any other ideas? I'm out of them...

Jan 30, 2015 11:49 PM in response to declure

Okay I found a partial solution. Our server is NetApp as well. Our admin is planning an ONTAP upgrade soon but for now SMB3 and Yosemite have problems communicating (not connecting per se) with this particular server; I tested the same files over SMB3 to my own OS X server and had no issues. The solve for this conversation is still absolutely correct but there's a caveat:


If you connect over SMB3 and try to open an Office file and get the file is damaged and need repair error, you can only cancel the message really but it turns out that Office 2011 still creates a lock file that's hidden to the OS, and fails to remove it. So even if you downgrade your connection to CIFS, Office 2011 (and ONLY Office 2011) sees the lock file and defaults to READ-ONLY. If you accidentally lock any file to READ-ONLY because of SMB3, just do this to unlock it and it will work fine in CIFS:


  1. In terminal use the command "defaults write com.apple.finder AppleShowAllFiles TRUE".
  2. Hold down Option/Alt and right-click (or Ctrl+Click) the Finder icon in the dock, select "Relaunch".
  3. You should now see the hidden lock files on the share starting with a ~ …Remove them (not always wise in standard practice but in THIS instance it's just a nuisance file).
  4. Now with a CIFS mount, all should work as normal again.
  5. To re-hide hidden files run the first and second steps again but change TRUE to FALSE.

Feb 2, 2015 9:03 AM in response to declure

Last but not least, the following Terminal command isn't completely necessary, but it helped to stupid proof all mounting even folder aliases and Profile Manager mounts:


echo "[default]" >> ~/Library/Preferences/nsmb.conf; echo "smb_neg=smb1_only" >> ~/Library/Preferences/nsmb.conf


Just delete the file and restart to undo. This command really helped to stabilize my setup though.

Apr 1, 2015 12:25 AM in response to declure

I am having what I think is a intimately related problem, but which is somewhat more aggravated. I have a server set up using FreeNAS 9.3, which is configured as Windows+CIFS (SMB) in order to facilitate for Windows-based computers to join. Permissions are consequently set-up with a Windows client (a MBP running Win7 in Bootcamp). Everything works fine as far as access and file transfer goes, but using any application changes the experience.


Just to be explicit, my problem is not only related to MS Office files, but also to PDFs and PNGs (I assume it is related to ALL files, but those are the ones I have tested). The problem arises, as for you other, when I try to save from within the application after I have altered the file's content. I get different messages depending on the application, but they all share the problem of not being able to save and that they after showing that error message, change the filename on the server (in the case of Word, it becomes 'Word work file L_2.tmp').

I have tried connecting to the server using Win7 and changing the same file and that works just as intended. I have also tried setting up a dataset (folder) on the server with only AFP and Mac settings and that works fine, but as Apple shifted to SMB from Mavericks it is not that enticing to set up a server with a dying technology, which is why I insist on getting the Windows/SMB share to work.


I have also tried the tips provided in this thread:

http://arstechnica.com/civis/viewtopic.php?f=19&t=1253789


1. smb://FreeNAS

2. cifs://FreeNAS (should force SMB1)

3. smb://FreeNAS:139 (should force connection over Netbios instead of TCP/IP)


None works.

I have checked the log files /var/log/samba4/log.smbd and /var/log/messages on the server, but they do not provide any error messages in this respect.


Based on declure's suggestion, I have copied a new Word file to the server -> disconnected from the server -> reconnected using 'cifs://servername' -> opened the Word file and tried to save it -> same error message ("Word cannot save this document due to a naming or permissions error on the destination volume."). As this works in Win7 it seems as the real problem resides not with the application (or is Office for mac faulty?), but with OSX.


Any constructive suggestions would be appreciated as I really would want this to work using SMB.

Apr 6, 2015 8:43 AM in response to Eniac74

Yeah I'm still having random bugs where one moment Office saves to a cifs share just fine, and the next it can't rename the temp file to the original file name and delete the original file (as it does in a save command). It throws roughly the same error you describe. I've tried remounting and that doesn't seem to immediately help. Sometimes rebooting helps, but the error comes back. To be honest I've just reverted to using my Windows VM since I don't have time for all these little bugs, and my system admin is loathe to upgrade our NetApp until the patches for Yosemite compatibility are tried and true. And that will probably happen far sooner than Apple will admit their SMB3 implementation is flawed in the fact that it requires vendors to develop specific patches just for it.


One suggestion I made was to enable NFS functionality. That may or may not be a legitimate suggestion to some (it wasn't in my case), but it could be for others. Get NFS working and you could potentially bypass all this SMB ridiculousness. Every iteration of SMB I've dealt with since Lion has been fraught with ridiculousness IMO. Fix it today it will still break tomorrow - that's Apple's SMB legacy so far. Where I really need a reliable share for OS X I'm just using their native AFP, and I'm sure they love it that way. Sorry I know that's more of a rant than a helpful answer, but it's been the cold hard truth in my experience so far.

Apr 12, 2015 11:18 AM in response to declure

Thanks for the input. After having searched the internet some more and counseled an OSX aficionado I have landed at the suspicion that there is some proprietary twist to Apple's SMB3. So...I reverted to using AFP/Mac for the FreeNAS setup (after having first upgraded to 10.10.3 to see if that helped the SMB setup).

Hopefully there will be some clarification down the road on this issue, but for now it just is not worthwhile to spend more time on finding a working solution with SMB. Maybe Apple should spend some more time though...

May 11, 2015 5:24 AM in response to declure

Hi Guys!


Just a clarification...


Switching from smb:// to cifs:// solves the issues in most cases. It is not a fix but a workaround. A fix would be smb:// to work from the beginning on a clean system. However, when using cifs:// there are cases where quicklook does not release the lock on the 8-digit temporary file that is created when you save an office document. If you switch the view in Finder to "list" where quicklook does not create previews of the files, and try again, then it should work even on network devices.


I hope this helps.


Best.

Jun 26, 2015 11:59 PM in response to declure

Thanks for the info. I have tried inputting the command you provided and it doesn;t do anything even after I restart my system. I even go to check my library folder and visually confirm that it is creating the file. It is. But when I connect up to the network share and try to open a word document I get the same error message.


What am I missing here and/or doing wrong. I am not an expert with Terminal but basically you typoe in this command at the prompt and hit "Return" correct? It then creates the file and that is then supposed to force SMB 1 connections.


It doesn't on my OSX Yosemite MacBook Pro Retina. How could Apple go an create a monumental problem like this for corporat eusers who want to use Microsoft office and also a file server on a network???/ This is astonishing.

Jul 6, 2015 10:10 AM in response to JG in SB

What command specifically? If it's showing hidden files, yeah nothing changes until you restart Finder. So either restart your macbook pro, or hold option and right-click the Finder icon in your dock, and select "Relaunch" - assuming that's what you meant.


Recently this issue became 100% solved in our organization. It just started working one day and I confirmed our administrator performed an ONTAP upgrade for our NetApp service. Both sides will probably point fingers across at one-another I'm sure. It would be nice to see Apple keep their SMB implementation to something that plays nice with other non-AFP/NFS centric solutions. With my users needing more and more bandwidth every year, CIFS has just got to go.

Can't open Office 2011 files on CIFS/SMB shares.

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