Excel 2007 - unhelpful messages

  • Thread starter Thread starter Martin Smulian
  • Start date Start date
M

Martin Smulian

Can anyone please help.

We have installed Office 2007 on some of our machines for evaluation, but wish
to continue using compatabilty mode (i.e. Office 2003) as documents are
regularly sent outside of the organisation for editing and return. These are
typically encrypted / password protected.

Whenever I save any changes to one of these in Excel 2007 I get

"This document is both encrypted and password protected. The Office Open XML
formats available in the 2007 release provide stronger encryption. Do you want
to increase the security og this document by converting to an Office Open XML
format?"

To which the answer is NO, not until I know that any recipients are also using
XML formats.

How can I stop this message from appearing every time I save a protected
document?
Martin
Just another confused user
 
Martin Smulian said:
How can I stop this message from appearing every time I save a protected
document?
Click to expand...

This is a guess since I don't have Excel 2007, but you may need to use
macros bound to the [Ctrl]+S key to save the active workbook, but that
disables messages before the save and reenables them afterwards.
Otherwise, I suspect there's as little way to eliminate your warning
message when saving as there is to disable the warning message about
losing some features when saving single worksheet files with no
formatting or formulas as CSV files.
 
That is certainly one solution. I was hoping that MS would have built in a
friendlier way or resolving this, especially as by introducing the new formats,
it is going to be many years before everyone has moved from xls, etc to XML type
documents.



Harlan Grove said:
Martin Smulian said:
How can I stop this message from appearing every time I save a protected
document?
Click to expand...

This is a guess since I don't have Excel 2007, but you may need to use
macros bound to the [Ctrl]+S key to save the active workbook, but that
disables messages before the save and reenables them afterwards.
Otherwise, I suspect there's as little way to eliminate your warning
message when saving as there is to disable the warning message about
losing some features when saving single worksheet files with no
formatting or formulas as CSV files.
Click to expand...

Martin
Just another confused user
 
Martin Smulian said:
That is certainly one solution. I was hoping that MS would have built in a
friendlier way or resolving this, especially as by introducing the new formats,
it is going to be many years before everyone has moved from xls, etc to XML type
documents.
Click to expand...
....

You're assuming Microsoft's definition of 'friendly' doesn't encompass
endlessly restating the obvious via warning dialogs. Alternatively,
you're failing to understand that Microsoft places greater importance
on idiot-proofing than expert's ease-of-use. The implicit assumption
that most of its users are idiots permeates all Microsoft software.
 
Back
Top