Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This issue has to deal with adding a Fluent UI tab according to the
procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx The section Im referring to is under the title: €œTo customize the Fluent UI by using Office Open XML Formats files€œ. This works according to article, however, if we go to Protect Workbook -- check the box next to Structure -- add a password -- save the document -- close the document -- follow the procedures in the MSDN article in order to make modifications to the Fluent UI using Office Open XML Formats. Once you add the .ZIP extension to the end of the file name, we get an error when trying to open the zip file. Title: Compressed (zipped) Folders Error Msg: The Compressed (zipped) Folder is invalid or corrupted. I have tried this similar case in Word 2007, but do not receive any error, so it is particular to Excel 2007. We are currently using Windows XP SP2 with Office 2007 Pro Plus, and I have tried this on Windows Vista Business with Office 2007 Pro Plus to determine if it is an OS issue, but received the same outcome so we feel it is a bug in Excel 2007 and the MSDN article. Thank you in advance for your attention to this possible bug in the Excel application. Please let us know any results/fixes/questions you may have. -- Nick |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A structure protected workbook is encrypted when it is saved by Excel and no
longer a zip file. You must unprotect it in order to manipulate its parts. -- Jim "Nick" wrote in message ... | This issue has to deal with adding a Fluent UI tab according to the | procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx | | The section I'm referring to is under the title: "To customize the Fluent | UI by using Office Open XML Formats files". | | This works according to article, however, if we go to Protect Workbook -- | check the box next to Structure -- add a password -- save the document -- | close the document -- follow the procedures in the MSDN article in order to | make modifications to the Fluent UI using Office Open XML Formats. Once you | add the .ZIP extension to the end of the file name, we get an error when | trying to open the zip file. | | Title: Compressed (zipped) Folders Error | Msg: The Compressed (zipped) Folder is invalid or corrupted. | | I have tried this similar case in Word 2007, but do not receive any error, | so it is particular to Excel 2007. | | We are currently using Windows XP SP2 with Office 2007 Pro Plus, and I have | tried this on Windows Vista Business with Office 2007 Pro Plus to determine | if it is an OS issue, but received the same outcome so we feel it is a bug in | Excel 2007 and the MSDN article. | | Thank you in advance for your attention to this possible bug in the Excel | application. Please let us know any results/fixes/questions you may have. | | -- | Nick |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the reply Jim.
Do you know why this behavior is allowed in Word 2007, when password protecting, and doesn't have the same restriction as Excel 2007? -- Nick "Jim Rech" wrote: A structure protected workbook is encrypted when it is saved by Excel and no longer a zip file. You must unprotect it in order to manipulate its parts. -- Jim "Nick" wrote in message ... | This issue has to deal with adding a Fluent UI tab according to the | procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx | | The section I'm referring to is under the title: "To customize the Fluent | UI by using Office Open XML Formats files". | | This works according to article, however, if we go to Protect Workbook -- | check the box next to Structure -- add a password -- save the document -- | close the document -- follow the procedures in the MSDN article in order to | make modifications to the Fluent UI using Office Open XML Formats. Once you | add the .ZIP extension to the end of the file name, we get an error when | trying to open the zip file. | | Title: Compressed (zipped) Folders Error | Msg: The Compressed (zipped) Folder is invalid or corrupted. | | I have tried this similar case in Word 2007, but do not receive any error, | so it is particular to Excel 2007. | | We are currently using Windows XP SP2 with Office 2007 Pro Plus, and I have | tried this on Windows Vista Business with Office 2007 Pro Plus to determine | if it is an OS issue, but received the same outcome so we feel it is a bug in | Excel 2007 and the MSDN article. | | Thank you in advance for your attention to this possible bug in the Excel | application. Please let us know any results/fixes/questions you may have. | | -- | Nick |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It's a good question why structure protecting a workbook leads to encrypting
in Excel 2007 when it didn't in Excel 2003 (or Word as you say). I haven't seen an explanation from MS on this. It used to be that only a File, Save password added encryption. I guess MS could say it makes it harder for someone to turn off structure protection by editing the file with a hex or XML editor but the same could be said for sheet protection which does not lead to encryption. I'm sure there's some logic there but we may never know it. -- Jim "Nick" wrote in message ... | Thanks for the reply Jim. | | Do you know why this behavior is allowed in Word 2007, when password | protecting, and doesn't have the same restriction as Excel 2007? | -- | Nick | | | "Jim Rech" wrote: | | A structure protected workbook is encrypted when it is saved by Excel and no | longer a zip file. You must unprotect it in order to manipulate its parts. | | -- | Jim | "Nick" wrote in message | ... | | This issue has to deal with adding a Fluent UI tab according to the | | procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx | | | | The section I'm referring to is under the title: "To customize the Fluent | | UI by using Office Open XML Formats files". | | | | This works according to article, however, if we go to Protect Workbook -- | | check the box next to Structure -- add a password -- save the | document -- | | close the document -- follow the procedures in the MSDN article in order | to | | make modifications to the Fluent UI using Office Open XML Formats. Once | you | | add the .ZIP extension to the end of the file name, we get an error when | | trying to open the zip file. | | | | Title: Compressed (zipped) Folders Error | | Msg: The Compressed (zipped) Folder is invalid or corrupted. | | | | I have tried this similar case in Word 2007, but do not receive any error, | | so it is particular to Excel 2007. | | | | We are currently using Windows XP SP2 with Office 2007 Pro Plus, and I | have | | tried this on Windows Vista Business with Office 2007 Pro Plus to | determine | | if it is an OS issue, but received the same outcome so we feel it is a bug | in | | Excel 2007 and the MSDN article. | | | | Thank you in advance for your attention to this possible bug in the Excel | | application. Please let us know any results/fixes/questions you may have. | | | | -- | | Nick | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I password protect a workbook in Excel? | Excel Discussion (Misc queries) | |||
XL2007 - password protect workbook? | Excel Discussion (Misc queries) | |||
Password Protect a Workbook ? | New Users to Excel | |||
password protect workbook | Excel Discussion (Misc queries) | |||
Auto Protect workbook with password upon opening | Excel Worksheet Functions |