Certain workbooks turn ON Reviewing Toolbar automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron_R - 28 Mar 2008 07:17 GMT

I receive financial data from the bookkeeper as an Excel workbook. Openning
these workbooks turns ON the Reviewing Toolbar. It then remains on, and
defaults on at next Excel start unless I remember to turn it OFF. This is
annoying as there are no Reviewers changes or comments on these workbooks.
Can this behavior be disabled?

I know I can Re-SAVE the file with the toolbar turned off, but the next
month's file will still turn on the Reviewing toolbar.

Reply to this Message

Gary''s Student - 28 Mar 2008 10:05 GMT

First open Excel and, then from Excel, open the workbook.

Signature

Gary''s Student - gsnu200776

> I receive financial data from the bookkeeper as an Excel workbook. Openning
> these workbooks turns ON the Reviewing Toolbar. It then remains on, and
[quoted text clipped - 4 lines]
> I know I can Re-SAVE the file with the toolbar turned off, but the next
> month's file will still turn on the Reviewing toolbar.

Reply to this Message

Dave Peterson - 28 Mar 2008 12:07 GMT

Gord Dibben posted this (originally from Jim Rech):

A recent posting from Jim Rech addresses this.

Jim post..................

If the workbook is sent as an attachment to Outlook then File, Properties
are automatically added which will make the Reviewing toolbar appear when
the workbook is opened in Excel. I don't know of a way to stop this.

However, once you open the workbook in Excel you can remove these properties
and save the workbook. After that it will no longer cause the reviewing
toolbar to appear. Here's an old message on that:

--------------

The Reviewing toolbar in Excel pops up whenever you open a workbook that has
been emailed from within Excel "for review". There may be other ways to
make this happen too. If you do a File, Properties you'll see the custom
file properties that have been added that triggers this.

You can kill the added file properties manually or run the below macro to do
it. This macro is in my Personal and attached to a toolbar button because I
feel the same way as you about this toolbar.

Signature

Jim Rech
Excel MVP

Sub KillReviewingCustProps()
Dim x As DocumentProperties
Dim Counter As Integer
Set x = ActiveWorkbook.CustomDocumentProperties
For Counter = x.Count To 1 Step -1
If Left(x.Item(Counter).Name, 1) = "_" Then _
x.Item(Counter).Delete
Next
CommandBars("Reviewing").Visible = False
End Sub

End Jim post.......................

Gord Dibben Excel MVP

Signature

Dave Peterson

Reply to this Message