Solved

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

Posted on 2014-12-20
9
264 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:Simon
ID: 40514144
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
ID: 40514158
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:Simon
ID: 40514168
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
ID: 40514198
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 18

Expert Comment

by:Simon
ID: 40514205
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
ID: 40514256
I'll try it.
0
 

Author Comment

by:weknowjack
ID: 40560241
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:
Simon earned 500 total points
ID: 40560313
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
ID: 40693562
Good info but not my solution. Mine may be a different problem.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Finder.   The ubiquitous, built-in feature of the Mac OS X platform, that never sleeps, can help get to any destination within your Mac OS X volume, allows you to customize your desktop, files and folders and so much more. As one of the primary…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
Viewers will learn the basics about Excel 2013’s new Flash Fill feature.

895 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

15 Experts available now in Live!

Get 1:1 Help Now