Microsoft KB Archive/61646

Multiplan: What Is Meant by Circular-Referencing Cells? PSS ID Number: Q61646 Article last modified on 06-11-1990 PSS database name: D_MPlan

3.00 4.01 4.01a 4.20

MS-DOS

Summary:

The circular reference report shows a list of all the cells that refer to another cell. The circular reference report differs from auditing cells in that it showing how cells refer to each other on the entire worksheet. Only cells that contain formulas are included in this report.

More Information:

Use the following procedure to print a cross-reference of cells:


 * 1) Select Report from the Run Command menu.
 * 2) Select Print, then select Cross-ref.
 * 3) In the “cell:” field, type the cell reference for the cells you want to examine. If you do not select a reference, Multiplan reports on the entire worksheet.
 * 4) Press the TAB key to move to the “reference:” field and press Y to select Yes if, for every cell containing a formula, you want Multiplan to print a list of the cells used in that formula.
 * 5) Press the TAB key to move to the “value:” field and press Y to select Yes if you want Multiplan to print the values contained in the cells.
 * 6) Press the TAB key to move to the “format:” field and press Y to select Yes if you want Multiplan to print the format of the cells.
 * 7) Press the TAB key to move to the “levels:” field and enter the number of indented levels that you want Multiplan to include in the report.
 * 8) Press the TAB key to move to the “indent:” field and enter the number of inches, centimeters, or characters that you want Multiplan to indent at each level.
 * 9) Press ENTER.

Copyright Microsoft Corporation 1990.