XL: Copying Tracer Arrows Gives Inconsistent Results

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you use the Copy Picture command to copy cells on a worksheet, and you select the Picture option, the tracer arrows are not copied. However, when you use the Copy Picture command to copy cells on a worksheet, and you select the Bitmap option, tracer arrows are copied.

WORKAROUND

If you want the tracer arrows to appear when you copy and paste cells on a worksheet, do the following:

1. Select the range containing the tracer arrows.

2. Press and hold down the SHIFT key, and choose Copy Picture from the Edit menu.

3. Under Appearance, select the As Shown On Screen option, and under Format, select the Bitmap option. Choose OK.

4. Select the cell you want to paste the picture to, and choose Paste from the Edit menu.

1. Select the range containing the tracer arrows.

2. Press and hold down the SHIFT key, and choose Copy Picture from the Edit menu.

3. Under Appearance, select the As Shown On Screen option, and under Format, select the Picture option. Choose OK.

4. Select the cell you want to paste the picture to, and choose Paste from the Edit menu.

MORE INFORMATION

You can use the Auditing command on the Tools menu to trace precedents, dependents, and errors related to any cell on your worksheet. The Tracer commands cause Microsoft Excel to draw arrows from the active cell to its precedents, its dependents, or to the possible source of an error value in the active cell. Tracer arrows aren't saved when you close the workbook. Tracer arrows are special "objects" that you can edit or manipulate in limited ways.

REFERENCES

For an Overview Of Using The Tracers To Audit Your Worksheets, choose the Search button in Help and type:

    tracers