Results 1 to 7 of 7

Thread: Excel 2007 file fails to get permission to open in Excel 2011

  1. #1
    Join Date
    Dec 2011
    Posts
    61

    Excel 2007 file fails to get permission to open in Excel 2011

    HI friends recently I was trying to open the Excel 2007 file in the Excel 2011 in office Mac 2011, but however it get open there in the Excel 2011 but whenever I try to make an update there in that sheet I get the message that the file is being protected and read only. But according to my information I have not make any of the internal setting to make Excel 2007 file protected or read only file. So I just want to know why these things happen there in Excel 2011 that it fails to update the file which is created in the lower version of Excel. If you people have any ideas or any suggestion for this then please let me know. I am very much confused please help.

  2. #2
    Join Date
    Aug 2011
    Posts
    566

    Re: Excel 2007 file fails to get permission to open in Excel 2011

    According to my information when you are trying to open that particular document in the Excel 2011, then see that whether the message popup for the sheet that it is ‘read only document’. If yes then you have to make the changes to the permission of that file, so for that you just have to alter the file permissions. And then you should try to make the update of the table may by altering the permission for that sheet will works.

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: Excel 2007 file fails to get permission to open in Excel 2011

    Try to open that file in Numbers, and see whether you are getting any of the message while opening that file in Number. And the alternate thing that you can do is to export and then re-opened it in excel this will works. And the thing that I know about these issues is that if the workbook contains some format which will fail to support there on the Mac Excel. So may be because of that reason the file become read-only on Mac Excel.

  4. #4
    Join Date
    Aug 2011
    Posts
    580

    Re: Excel 2007 file fails to get permission to open in Excel 2011

    There may be the chances that your workbook have feature "Protect Range", so for that you have to delete "Protect Range" feature from your workbook. So it is easy to delete ‘Protect Range’ with these easy steps:
    • So for that First, Click Ribbon->Review->Changes->Unprotect Sheet. There you have to Input the password to unprotect the sheet
    • And then Click Ribbon->Review->Changes->Allow Users to Edit Ranges. There you can delete all protected ranges

  5. #5
    Join Date
    Jul 2011
    Posts
    434

    Re: Excel 2007 file fails to get permission to open in Excel 2011

    I think this is sure that the sheet that you are using is 100% protected so first make the verification for the rights that you have given to that work sheet. Because the Excel is showing that the file that you are trying to open is protect, means it is sure that the file you are trying to open in Excel 2011 is protected.

  6. #6
    Join Date
    Jul 2011
    Posts
    440

    Re: Excel 2007 file fails to get permission to open in Excel 2011

    According to my information, you just try to boot your laptop with windows 2007 and it will allow you to enter data into the excel sheet. And there see whether the protection is on if yes then make it off and then try to re-opened that document in excel 2011.

  7. #7
    Join Date
    Nov 2010
    Posts
    422

    Re: Excel 2007 file fails to get permission to open in Excel 2011

    Even I was also getting the same issue for opening the lower version Excel sheet in to the higher version Excel sheet in my Mac OS, but when I try Windows it works fine. So maybe this is the compatible issue for such file in Mac OS.

Similar Threads

  1. Microsoft Excel 2007 fails to open DBF File
    By New!life in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:43 PM
  2. Can I open .wk4 file in Microsoft Excel 2007
    By DawnSet in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 07:42 PM
  3. Replies: 2
    Last Post: 15-02-2012, 08:14 PM
  4. Cannot open Excel 2007 file
    By DeMario in forum Windows Software
    Replies: 4
    Last Post: 06-11-2009, 11:22 PM
  5. Open a .wb3 file with Excel 2007
    By avvia in forum Windows Software
    Replies: 3
    Last Post: 10-06-2009, 11:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,642,364,344.08105 seconds with 17 queries