ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Spreadsheet Trace Precedent Bars not showing up (https://www.excelbanter.com/excel-worksheet-functions/130093-excel-spreadsheet-trace-precedent-bars-not-showing-up.html)

MarieM

Excel Spreadsheet Trace Precedent Bars not showing up
 
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.

Dave F

Excel Spreadsheet Trace Precedent Bars not showing up
 
Check to see if your cursor is in the formula bar. If the formula bar is
active you can't audit formulas.

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


"MarieM" wrote:

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.



All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com