Trace Audting Grayed out

G

Guest

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
 
G

Guest

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

Dave
 
G

Guest

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

Excel Spreadsheet Trace Precedent Bars not showing up 1
Data Validation drop down not showing and Formula Auditing bar greyedout 2
Unable Access Trace Precedents/Dependents Auditing Tool 1
menu grayed out 2
Toolbars are grayed out 1
In Excel 2007, how does one view horizontal and vertical rulers? 2
Template & Trace Precedent/Dependent Problem 1
Outlook "Follow UP' Grayed Out 3

Top