cannot use auditing tools

[Billy]

i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso

 

[Billy]

i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso

Also, the drawing tools are not hightlighted either.
Tonso

 

[Gord Dibben]

What do you consider as a "spreadsheet"?

A workbook or a worksheet within a workbook?

Sounds to me like your worksheet is protected under Tools>Protection>Protect
Sheet.


Gord Dibben MS Excel MVP

i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso

Also, the drawing tools are not hightlighted either.
Tonso

 

[Billy]

What do you consider as a "spreadsheet"?

A workbook or a worksheet within a workbook?

Sounds to me like your worksheet is protected under Tools>Protection>Protect
Sheet.

Gord Dibben  MS Excel MVP

i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso

Also, the drawing tools are not hightlighted either.
Tonso- Hide quoted text -

- Show quoted text -

Gord,
I meant worksheet. To be exact, the workbook in question has 6
worksheets, none of which are protected. On every sheet, the auditing
tools (trace precedents, trace dependents), along with drawing tools
(cirlces, rectangle, lines, etc.) cannot be accessed. Cells can be
merged, formatted, borders added, but no trace precedents/trace
dependents, which is what I want to do. I tried protecting and then
unprotecting the worksheets.
Tonso

 

[Gord Dibben]

Without protecting a sheet, I can't find a way to replicate your problem in
version 2003.

Something both of us are missing......hopefully we will get some more
suggestions from the group.


Gord

 

[sysmod]

Try
View > Toolbars > Customize... > Reset

No drawing objects or multiple tabs selected?

Try Copy all to a new sheet

Check out
http://www.mvps.org/dmcritchie/excel/grayedout.htm

http://www.mvps.org/dmcritchie/excel/toolbars.htm

HTH

Patrick

 

[Barbara Wiseman]

Tonso,
Could it be that you have several sheets selected, after the workbook name
at the top of the excel window does it have [group]. If so right click on
one of the sheet tabs and click on ungroup sheets.
Barbara.

 

[Tonso]

Tonso,
Could it be that you have several sheets selected, after the workbook name
at the top of the excel window does it have [group].  If so right click on
one of the sheet tabs and click on ungroup sheets.
Barbara.

i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso- Hide quoted text -

- Show quoted text -

No, there are no grouped sheets.
Tonso

 

[Tonso]

Tonso,
Could it be that you have several sheets selected, after the workbook name
at the top of the excel window does it have [group].  If so right click on
one of the sheet tabs and click on ungroup sheets.
Barbara.

i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso- Hide quoted text -

- Show quoted text -

There are several workbooks that are linked to this workbook.
Tonso