Excel Spreadsheet Trace Precedent Bars not showing up

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarieM - 09 Feb 2007 19:54 GMT

HI, I have a spreadsheet with formulas. When I go to Tools Options, Formula
Auding the Trace Precedent Bars are grayed out. Why?

When I go to tools options view and click on view all, it shows up, BUT IT
PLACES A BOX WITH A SCROLLING BAR ON IT that I cannot get rid of.

What is this box?

Why is the trace Precedent Bars grayed out.

I am using Office 2003.

Reply to this Message

Dave F - 09 Feb 2007 19:57 GMT

Check to see if your cursor is in the formula bar. If the formula bar is
active you can't audit formulas.

Dave

Signature

A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

> HI, I have a spreadsheet with formulas. When I go to Tools Options, Formula
> Auding the Trace Precedent Bars are grayed out. Why?
[quoted text clipped - 7 lines]
>
> I am using Office 2003.

Reply to this Message