• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Displaying Tracer Arrows

Q1:The Auditing toolbar buttons or menu options are unavailable.
A1: If the worksheet isn't protected (you can't audit a protected worksheet), and the auditing features are unavailable, your Excel options are set up to hide graphical objects (which include tracer arrows). The auditing feature relies on tracer arrows to indicate errors, precedents, and dependents. To display the tracer arrows, choose Tools, Options to open the Options dialog box. Click the View tab, and select either Show All or Show Placeholders in the Objects section.

Auto Outline Doesn't Work

Q1:Why do I get the error message "Cannot create an outline?"
A1: Excel understands only outlines that are set up consistently. Be sure you don't have inconsistent spaces between categories and totals, and that the rest of the list is organized in a consistent manner.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint