[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2014-12-20
9
Medium Priority
?
330 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

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
 
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 1500 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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

In this article we have discussed about the OS X EI Capitan and how to fix Wi-Fi issue in OS X El Capitan. We have explained how to delete system level preferences and create a new Wi-Fi location to resolve Wi-Fi issue.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.

591 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