Unable to activate Trace Precedents or Dependents in Excel 2003

Unable to activate Trace Precedents or Dependents in Excel 2003

Post by davebor » Fri, 05 Dec 2008 07:30:34


I have an Excel 2003 file and Formula Auditing is activated on the
Menu bar. But on the Formula Auditing menu the Trace functions do not
"activate" or light "light up" when I I have my cursor on a cell with
a formula. Thus, no Trace lines appear. I activated Circular
Reference in menus as well and the same thing happens, i.e., the
Tracer lines will not activate on the menu (the buttons do not
activate).

I did not create this file, it was given to me by a coworker. All
auditing features work in my own Excel files.

Any ideas on how to activate the Tracer buttons? (The person who
provided the file does not know.)

Thank you.
 
 
 

Unable to activate Trace Precedents or Dependents in Excel 2003

Post by Gord Dibbe » Fri, 05 Dec 2008 07:42:04

Sounds like maybe the worksheet is protected.

Tools>Protection>Unprotect Sheet


Gord Dibben MS Excel MVP

 
 
 

Unable to activate Trace Precedents or Dependents in Excel 2003

Post by davebor » Fri, 05 Dec 2008 09:35:01


Thanks for the reply. I checked the Protection status and it is
already Unprotected. However, I copied each Tab in the file into a
blank worksheet on my PC and the "new" copied file has no problems,
i.e., the Tracer functions work as normal. Very strange.
 
 
 

Unable to activate Trace Precedents or Dependents in Excel 2003

Post by Gord Dibbe » Fri, 05 Dec 2008 09:54:07

Strange indeed but glad to hear you're up and away.

Gord
 
 
 

Unable to activate Trace Precedents or Dependents in Excel 2003

Post by Mr. Man876 » Sun, 07 Dec 2008 03:57:23


Okay, a coworker searched and searched and found the correction. You
have to go to Tools and then Options. I never thought of reviewing
Options under Tools because Formula Auditing has its own selection
under Tools. Oh well, whoever created the file to begin with turned
it off in this section.
 
 
 

Unable to activate Trace Precedents or Dependents in Excel 2003

Post by Gord Dibbe » Mon, 08 Dec 2008 04:44:39

Tools>Options and then what?

I assume you mean Tools>Options>View>Objects>Hide All.

I never thought of that<g>


Gord

On Fri, 5 Dec 2008 10:57:23 -0800 (PST), "Mr. Man8760" < XXXX@XXXXX.COM >