Solved

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

Posted on 2014-12-20
9
293 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Deploystudio is a system which can be used to deploy OSX clients and servers within the small/medium or large business environments. The system is built onto of the OSX Server NetBoot system and uses images & workflows as its core assets. While work…
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.
Viewers will learn how to find and create templates in Excel 2013.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

728 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