Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Protected Excel file

  • 25-06-2012 7:27pm
    #1
    Closed Accounts Posts: 338 ✭✭


    Hi,

    i have an excel file who's spreadsheets are locked / protected.

    All i want to do is to copy the cells from one of the excel spreadsheet , and paste them into a new spreadsheet - but i can not do so.

    i can not select any of the cells on any of the spreadsheets on the file.

    can anyone help?

    there are no formulas or anything in the spreadsheets, just text.

    it would be a great help.

    thanks

    Jo


Comments

  • Registered Users, Registered Users 2 Posts: 617 ✭✭✭Shhh


    Can you print it to a PDF and then copy from the PDF into word?


  • Registered Users, Registered Users 2 Posts: 1,688 ✭✭✭Sup08


    DId you try a "Save as" and then try copy? Check the file properties to ensure it is not read only. If you cannot change this then try the new file you saved.


  • Registered Users, Registered Users 2 Posts: 2,367 ✭✭✭fionny


    I never understand why people protect their sheets to that level. You could ask for the password or there are tools for recovering lost excel sheet passwords you could look up.


  • Registered Users, Registered Users 2 Posts: 1,688 ✭✭✭Sup08


    This looks interesting, let me know if you try it and works.
    It says it only works if you can open the workbook initially.

    http://www.straxx.com/free-excel-password-remover-2012/


  • Registered Users, Registered Users 2 Posts: 2,367 ✭✭✭fionny


    Sup08 wrote: »
    This looks interesting, let me know if you try it and works.
    It says it only works if you can open the workbook initially.

    http://www.straxx.com/free-excel-password-remover-2012/

    I just tried it on a random sheet and it worked straight away :)


  • Advertisement
Advertisement