shared workbook issue

[Brendan Quirk]

Hello All - I am using Excel 2007 and have a shared workbook that is
also password protected.

One user of the workbook attempted to save changes and received an
error message that reads:

"Caution: You are attempting to save a shared workbook that is also
protected with a 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 this file?"

I would like to keep this as a shared workbook, so I attempted to
delete the change history by going to Review>Changes>Share
Workbook>Advanced, and the radio button is 'on' for "Don't keep change
history."

Can someone please guide me about what steps I must take in order to
keep this a shared workbook, but to eliminate this error message each
time someone would like to save a change? Thank you, Brendan

 

[Simon Lloyd]

It should stay a shared workbook unless specifically unshared, was th
user doing a SaveAs or a simple save

Hello All - I am using Excel 2007 and have a shared workbook that i
also password protected

One user of the workbook attempted to save changes and received a
error message that reads

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

I would like to keep this as a shared workbook, so I attempted t
delete the change history by going to Review>Changes>Shar
Workbook>Advanced, and the radio button is 'on' for "Don't keep chang
history.

Can someone please guide me about what steps I must take in order t
keep this a shared workbook, but to eliminate this error message eac
time someone would like to save a change? Thank you, Brenda

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com