Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Protected Excel file

  • 25-06-2012 08:27PM
    #1
    jocotty
    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
    Tagged:


Comments

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


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


  • #3
    Sup08
    Registered Users, Registered Users 2 Posts: 1,697 ✭✭✭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.


  • #4
    fionny
    Registered Users, Registered Users 2 Posts: 2,369 ✭✭✭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.


  • #5
    Sup08
    Registered Users, Registered Users 2 Posts: 1,697 ✭✭✭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/


  • #6
    fionny
    Registered Users, Registered Users 2 Posts: 2,369 ✭✭✭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