Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Auditing/ tracing

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training - Auditing/ tracing

Resolved · Low Priority · Version Standard

Reply Mon 30 Jul 2007, 16:10Delegate Andrea said...

Andrea has attended:
Excel Intermediate course
Excel Advanced course

Auditing/ tracing

If using the tracing commands to investigate formulas in cells, if the formula refers to cells on other sheets than the one I am working on, how do I find out where on another sheet the origin is?

For upcoming training course dates see: Pricing & availability

Reply Wed 1 Aug 2007, 10:24Trainer Amanda said...

RE: auditing/ tracing

Hi Andrea

Thank you for your question.

What will happen when you use Trace Error where the cell in question refers to cell/s on other sheets, you will get a dashed line and a little spreadsheet icon appear on the spreadsheet. If you double-click at any point along the dashed line, the Go To dialogue box will appear on your screen listing the cells that are referred to in the formula so that you can select a cell reference from here and click OK to go to that cell and investigate what the problem might be.

I hope this helps.
Amanda

Excel articles

· Microsoft Excel Training: Not Just for Newbies Anymore
· The Key Settings In Excel 2003's Options Panel
· Data Basics Using Excel
· Radio Buttons And Check Boxes In Excel
· Which Is Better, Excel Or Access?

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips