Results 1 to 4 of 4
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Encryption Error (xl2000 SR2)

    I found this error in Excel's help system. It's exactly what my users see (their encrption message):

    "I can't open a workbook because it was protected with an encryption scheme that is unavailable. Some workbook protection and encryption features vary depending on the language of the operating system they were created in. Before you can open a protected workbook, you must unprotect it by using the same operating system and language in which it was created.

    For example, if you are using the U.S. English version of Windows and receive a workbook that was protected by using the Danish version of Windows, you can open the workbook only after it is unprotected by using the Danish version."

    There has to be a workaround because I can't possibly have all language versions on my test system and distribute a protected version in each language. This is getting really scary.There has to be many people here who develop for users outside of their own country. If I can't solve this then I'll have to totally redesign my VBA apps to not use any code whatsoever which of course drastically changes what features I can offer.

    Thnx, Deb <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Encryption Error (xl2000 SR2)

    According to <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278679&id=278679&SD=MSKB>OFF2000: "This Workbook (Document) Has Been Password Protected" [Q278679]</A> there is a patch.
    Charlotte

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Encryption Error (xl2000 SR2)

    FANTASTIC!! My user is in Belgium and has the French regional settings so this must be the problem. I had a user in China who had no problems running the same workbook. I will contact MS tomorrow and get the patch. It'll be available in the next Office service pack but I need the fix now and the link says I can get it.

    I will still get another test PC to install an International version of Office for testing purposes and to try other regional settings.

    Thank you so much for finding this, I had searched the KB but as usual came up empty.

    Deb <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21> <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21> <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Encryption Error (xl2000 SR2)

    I posted this same question in the Excel forum (post <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=101508&page=0&vie w=expanded&sb=5&o=0&vc=1>#101508</A>) since I don't know yet if it's a problem with Excel or my VBA.

    I have an Excel VBA project that works fine in US, no errors but my Europe users are not able to use the workbook at all and are reporting some type of 'encryption' error (that it's not valid in their region). The only protection in the workbook is that some sheets are protected as is the workbook itself and the VBA project code. They are given the worksheet/book password but not the password to the code. I do not have any digital signature applied.

    Could it be that the encryption used to protect the sheets on my English US version is conflicting with whatever these guys have? I have requested more info as far as exact message text, when it appears, screen shot, etc.

    I have also sent them two identical test workbooks. One has no protection at all, the other has only the project/code protected. I am also acquiring an International version of Excel to use as a test bed. I always have struggled getting the same code to work in xl97 and xl2000 but now I have to deal with 100 different countries! <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

    Thnx, Deb <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •