+ Reply to Thread
Results 1 to 2 of 2

Workbook password protected in Excel 2013, re saved in earlier version protection removed

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    2

    Workbook password protected in Excel 2013, re saved in earlier version protection removed

    I have created a workbook in Excel 2013 that is used by my clients to calculate their payroll for them. I hide certain tabs that contain the bulk of the formulas used to create the calculations, and lock most cells in the worksheets that are to be used by my clients, allowing them to only edit portions that they need to in order to adjust their payroll (change hours, rates, etc). The workbook itself is then password protected to prevent them from interfering with the formula's on the hidden tabs. I save it as a 2013 file, then email it out to my clients, some of whom have earlier versions of excel (one had Excel 97, as an example, others have 2003). Once they have opened, and then edited the fields they need to, they re save the file, this time as an earlier version, and send it back to me, and when I open it up and go to unlock the workbook and sheets, Excel does not ask for me to enter the password, it just unlocks it with a click on "Unprotect." I am worried that this means my workbook is really not that protected, if it means all someone has to do is open it using an earlier version of Excel to wipeout the protection. I've also noticed this happening to greater effect when I share my workbook with Mac users, only on those occasions, the entire workbook comes back with all tabs unhidden and unlocked, with all password protection removed. Can you please tell me if there is a way I can prevent this from happening? Thank you.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,701

    Re: Workbook password protected in Excel 2013, re saved in earlier version protection remo

    Few Questions:-

    Created file in 2013 supplied it to the end user with which extension .xls OR .xlsm/.xlsb?

    As far as I know 2007/2010/2013 Password Encryption method is little bit advanced when comparing to 2003/97 workbook.

    Unhiding of hidden sheet can be done easily by a simple loop from another workbook, but not sure how you coded.

    Breaking of excel password not even take more time and excel is not that kind of application to maintain the security in utmost level.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Audit trail saved in a separate, password protected Excel file?
    By lonely707 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 04:26 PM
  2. Open xlsx with earlier version of Excel (especially 97)
    By martindwilson in forum Tips and Tutorials
    Replies: 2
    Last Post: 05-18-2008, 12:52 PM
  3. Replies: 1
    Last Post: 01-18-2006, 12:45 PM
  4. Replies: 3
    Last Post: 06-16-2005, 11:05 PM
  5. [SOLVED] How to use excel file created in version earlier than 4.0a in 4.0
    By ajimmo in forum Excel General
    Replies: 4
    Last Post: 05-30-2005, 06:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1