Solved

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

Posted on 2014-12-20
9
288 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

With the major release of Apple's 7th addition to the Mac OS X family, Mac OS X 10.6 Snow Leopard, there are a lot of enhancements which have arrived with this new OS X upgrade. With the number of enhancements and refinements I can provide deta…
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 the different options available in the Backstage view in Excel 2013.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

740 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