Trace Audting Grayed out

M

MarieM

My Excel 2003 question is the following on an unprotected workbook.

1. Why would the following toolbars be GRAYED OUT on a spreadsheet with tons
of formulas.
Tools:Formula Auditing: TRACE PRECEDENTS, TRACE DEPENDENTS, TRACE ERROR,
REMOVE ALL ERRORS.

2.) When I click on Tools Options General, and under Objects click on SHOW
ALL I get a skinny vertical scroll bar that I cannot close nor can I do
anything with it. It does blink though if I click on the bar in the middle. I
cannot move it anywhere either.

THanks for any help.
Michele
 
D

Dave F

The auditing tools are grayed out when the formula bar is active. Try
selecting a cell.

Dave
 
M

MarieM

Dave thank you but that is not the problem. This a spreadsheet with 5 sheets
wiht the following properties, 5 worksheets, 1 chart and 5 named ranges. I am
not sure what more details you need. The only way i could turn on the trace
precedent was to turn on View all in Objects in Tools, Options. This produced
a scroll bar. Any more clues? What details should I post?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auditing tools suddenly grayed out 6
Excel Spreadsheet Trace Precedent Bars not showing up 1
Trace dependents - can it auto-update / is there a keyboard shortc 0
Trace Precedents 1
how can I find out trace dependents on other pages 3
Data Validation drop down not showing and Formula Auditing bar greyedout 2
Trace Dependencies Dialog 0
Trace Dependents not working 3

Top