A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Msg: "Drawing Objects...protected" won't save



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 03:34 PM posted to microsoft.public.excel.misc
christophercbrewster via OfficeKB.com
external usenet poster
 
Posts: 143
Default Msg: "Drawing Objects...protected" won't save

I'm using an XLS spreadsheet in Excel 2007, and I can't save it in either the
old or new format. the message says "Drawing Objects in one or more sheet(s)
in the workbook are protected. Please unprotect them and try to save again.
I've selected all the sheets and clicked Unprotect, but I still get this
message. Can anyone tell me how to find these objects, and how do I unprotect
them?

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via http://www.officekb.com

  #2  
Old June 3rd, 2010, 05:30 PM posted to microsoft.public.excel.misc
Tom Hutchins
external usenet poster
 
Posts: 722
Default Msg: "Drawing Objects...protected" won't save

You can't protect or unprotect all the sheets at once. You have to unprotect
them individually. I have seen this message caused by an add-in (Hyperion
SmartView), which stores information in hidden objects on the sheets.
Unprotect each sheet. When you re-protect them, be sure the 'Edit objects'
checkbox in the Protect worksheet dialog is checked.

Hope this helps,

Hutch

"christophercbrewster via OfficeKB.com" wrote:

I'm using an XLS spreadsheet in Excel 2007, and I can't save it in either the
old or new format. the message says "Drawing Objects in one or more sheet(s)
in the workbook are protected. Please unprotect them and try to save again.
I've selected all the sheets and clicked Unprotect, but I still get this
message. Can anyone tell me how to find these objects, and how do I unprotect
them?

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via http://www.officekb.com

.

  #3  
Old June 3rd, 2010, 08:54 PM posted to microsoft.public.excel.misc
christophercbrewster via OfficeKB.com
external usenet poster
 
Posts: 143
Default Msg: "Drawing Objects...protected" won't save

Thanks for the response. Uncanny how you knew that Hyperion SmartView is
installed. (I was documenting it-- I'm not in financial planning). Anyway, I
was doing the Unprotect step one sheet at a time but something was still
getting missed. But since I'm changing over to Office 2007, I saved as the
XLS as XLSX and the problem somehow went away.

Tom Hutchins wrote:
You can't protect or unprotect all the sheets at once. You have to unprotect
them individually. I have seen this message caused by an add-in (Hyperion
SmartView), which stores information in hidden objects on the sheets.
Unprotect each sheet. When you re-protect them, be sure the 'Edit objects'
checkbox in the Protect worksheet dialog is checked.

Hope this helps,

Hutch

I'm using an XLS spreadsheet in Excel 2007, and I can't save it in either the
old or new format. the message says "Drawing Objects in one or more sheet(s)
in the workbook are protected. Please unprotect them and try to save again.
I've selected all the sheets and clicked Unprotect, but I still get this
message. Can anyone tell me how to find these objects, and how do I unprotect
them?


--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via http://www.officekb.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.