Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Misbehaving » Saving a protected shared workook in Excel 2003

Saving a protected shared workook in Excel 2003

Previous | Next
Latest post Fri, Nov 14 2008 5:51 AM by Jan Karel Pieterse. 4 replies.

  • Mon, Nov 10 2008 1:00 PM

    • ali.syed
    • Top 200 Contributor
    • Joined on Tue, May 6 2008
    • Posts 4
    • Points 100

    Saving a protected shared workook in Excel 2003

    Reply |Contact

    Hello All Experts,

    I have an excel fie on the file server. This file is shared and password protected and also is used by multiple persons simultaneously. I have two questions to ask.

    Every time the user tries to save this file, they get the Microsoft Excel Message Box, which as says as Following:

    Caution: You are attempting to save a shared workbook that is also protected witha password. Portions of the file, including the change history, will not be encrypted. To help ensure the security of your file, unshare the workbook or delete the change history from the document. Do you want to save the file?

    Question # 1. How do I disable this caution box?

    Question # 2. My users have complained that after saving this file all of the entered data is lost. As if they haven't entered anything into the file.

    Please assist. Thanks in advance. 

    P.S: This file has auto save and auto backup also.

    P.S: This file has autosave and autoback also.

     

     
    • Post Points: 21

  • Mon, Nov 10 2008 3:41 PM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 543
    • Points 9,287
    • MVP

    Re: Saving a protected shared workook in Excel 2003

    Reply |Contact |Mark as Answer

    Ali

    What I will say here is not an answer really, but i'm afraid it is the truth. No one should share an Excel file. Excel is not a sharing application, databases generally are.

    I suspect what is happening here is that several people are making changes at the same time and therefore only the last wins from the chnage history.

    I think you will find no one on this board who would have experience of sharingan Excel file as it is such a bad idea.

    Sorry that sound so lame

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    • Post Points: 21

  • Thu, Nov 13 2008 10:01 AM In reply to

    • ali.syed
    • Top 200 Contributor
    • Joined on Tue, May 6 2008
    • Posts 4
    • Points 100

    Re: Saving a protected shared workook in Excel 2003

    Reply |Contact |Mark as Answer

    Nick

    Thanks for the reply. I know what you are saying. I have a pretty bad experience with the Excel sharing. 

    How about disabling that prompt when saving the file?

    Thanks once again.

     
    • Post Points: 37

  • Fri, Nov 14 2008 2:40 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 543
    • Points 9,287
    • MVP

    Re: Saving a protected shared workook in Excel 2003

    Reply |Contact |Mark as Answer

    Ali

     

    You may want to try controlling the Save process from code as I detailed here:

    http://excelusergroup.org/forums/p/947/2919.aspx#2919

    Whether that will work in tis case I don't know but you would us application.DisplayAlerts = False before the save and the 'True' after the save. Let me know if you need help with the VBA

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    • Post Points: 5

  • Fri, Nov 14 2008 5:51 AM In reply to

    Betreft: Re: Saving a protected shared workook in Excel 2003

    Reply |Contact |Mark as Answer

    Hi,

    Lke Nick said: (and I'll shout this time!!)

    DON'T DO THIS!

    Sharing workbooks is a very bad idea. Get your people to find a different solution altogether.

    Regards, Jan Karel Pieterse www.jkp-ads.com
    • Post Points: 5
Page 1 of 1 (5 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.