Excel 2003

  • Thread starter Thread starter philiphales
  • Start date Start date
P

philiphales

Our company has just upgraded us to XP, along with that we now are usin
Office 2003. I like some of the new Excel error tracking, but am havin
recurring problems with a couple of other aspects.

The first is - having set the toolbars with all the things I like t
have to hand - when opening some sheets I suddenly get WEB an
REVIEWING toolbars popping up - not only do these reduce the amount o
screen when closing said sheets they remain - WHY DO THEY APPEAR? If
right click and uncheck the box they go, but not permanently.

The other annoyance is I use CTRL+INSERT to copy then ENTER to past
after a couple of goes the stupid clipboard appears hiding everything
go to options and uncheck everything and start cutting and pasting an
the hideous thing pops up again.

How do I permanently stop these two infuriating things from happening
 
Effect
Sometimes, when an email you receive contains an Office attachment, the
attachment, when opened, will also open the "Reviewing" toolbar.
This applies mainly to Excel 2003, although the effect might be seen in
other versions.

Cause
The email/attachment has been sent using Outlook which has automatic review
turned on.
Outlook sometimes adds custom properties to Office attachments, including
your email address.
Another is "_ReviewingToolsShownOnce"

Resolutions
After saving these files for the first time, the "Reviewing" toolbar
shouldn't appear again.

Or

Delete the custom properties
Open the Office document
Click File in the menu bar
Then click Properties
Select the Custom tab
Select each property you wish to remove and click Delete
Or

Ask your colleagues to change their Outlook settings:
How to Turn Automatic Review Off in Outlook
Click Tools in the menu bar
Select Options
On the Preferences tab click E-mail options.
Then click Advanced E-mail options.
At the bottom disable "Add properties to attachments to enable Reply with
Changes"

Other
How can I still send documents for review?
On the File menu select "Send to"
Select "Mail Recipient (for Review)"

see: http://www.bygsoftware.com/Excel/InterFace/reviewing_toolbar.htm

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"philiphales" <[email protected]>
wrote in message
news:p[email protected]...
 
Back
Top