Solved

Excel 2011 Mac sheet is not locked but pops up "is read only"

Posted on 2014-12-20
9
255 Views
Last Modified: 2015-03-28
I have an Excel worksheet that is in a shared folder in my Mediafire account. When I try to open it from a computer different from the one I created it with, I get a popup that the file is read-only and when I try to change permissions in Excel, I get "Your computer isn't set up to use restricted permissions."

Using Excel Mac 2011. How do I correct this? I have used the "Get Info" and set the file to be readable and writable by everyone. Still get the popup.
0
Comment
Question by:weknowjack
  • 5
  • 4
9 Comments
 
LVL 18

Expert Comment

by:SimonAdept
Comment Utility
Are you using a student/home/365 or full version of Office 2011?
Have you tried copying the workbook to your local hard drive first? This is not intended to be a solution, but just a diagnostic step.
I think there is a separate type of restriction (digital rights management) that can be applied, which is not related to filesystem access control settings. Do you use this?
Open a file that has restricted permissions
0
 

Author Comment

by:weknowjack
Comment Utility
Full version. I don't know how to use the digital rights management. I've uploaded/downloaded an opened/edited many excel files without this issue. I have one that is shared and I keep it open on different machines. It is also kept in Mediafire. I have checked all the security settings in Excel that I can find. Everything seems to be open, but I still get the read-only message.
0
 
LVL 18

Expert Comment

by:SimonAdept
Comment Utility
Thanks. Is this one "shared and I keep it open on different machines"? I'm unfamiliar with Mediafire, but it would figure that if the file was already open elsewhere that it would be marked read-only.
Is this workbook set as a shared workbook in Review/Share Workbook?
0
 

Author Comment

by:weknowjack
Comment Utility
I was just giving you an example of other files that don't have the same issue from the same location. The example file is open on more than one machine simultaneously. Yes I have it set to share.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 18

Expert Comment

by:SimonAdept
Comment Utility
And are the other files that you are working with successfully also set to share (allow changes from more than one user at the same time)?
The shared workbook feature imposes a lot of restrictions. I'd try testing with sharing disabled.
0
 

Author Comment

by:weknowjack
Comment Utility
I'll try it.
0
 

Author Comment

by:weknowjack
Comment Utility
I think it has something to do with user id on different machines. Still not sure what to do. It was working before on other machines just fine. The Macbook Pro I'm using is the problem.
0
 
LVL 18

Accepted Solution

by:
SimonAdept earned 500 total points
Comment Utility
I'm sorry, but I'm about out of ideas. I found these external links
http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macword/how-can-i-fix-your-computer-isnt-setup-to-use/ca5f6da7-44c6-4b38-9c0f-5c94c2a022bc
and
https://support.office.com/en-us/article/Open-a-file-that-has-restricted-permissions-1d5fe8df-fdd3-4e56-b99f-f2c4ae2d0ae5

The specific error message you mention does appear to be related to rights management. Is it possible that the other machines you access the file from are on a network (with access to a licencing server) whilst your Macbook is not?
0
 

Author Closing Comment

by:weknowjack
Comment Utility
Good info but not my solution. Mine may be a different problem.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

If you other experts are anything like me you are always looking into and testing out new features. While I was doing some research one day I ran across an app that I installed on my Mac and used as a security system. Mac OS X: SecureHome uses your …
The error "There was an error performing the update" occurred on a Mac OS X client workstation running  Symantec AntiVirus for Mac (http://www.symantec.com/business/products/purchasing.jsp?pcid=pcat_security&pvid=825_1) - the Enterprise product vers…
Viewers will learn how to apply various conditional formatting in Excel 2013.
Viewers will learn various types of data validation for different data types in Excel 2013.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now