Excel: Formula Viewer Macro Displays Unexpected Data

 Last reviewed: October 31, 1994
Article ID: Q50449

SUMMARY

The first time the Formula Viewer macro is executed during an editing session in Excel, the summary report may display financial information that is not present in the worksheet that the summary report is generated from. The amount of financial information displayed depends on how large the selection area is when the macro is run. Additional executions of the macro do not produce this unrelated information.

The Formula Viewer macro has this financial information entered into column N of the macro sheet. The first time the macro is run, the selected information from the worksheet is inserted into column N and any cells that are not overwritten display the financial information. When the macro finishes creating the summary report, it clears column N. This is why the financial data only appears on the first run of the macro. When the macro closes, it does not save the changes made to it, allowing every initial execution of the macro to revert to the financial information stored in column N.

MORE INFORMATION

The following steps will delete this extra information in column N of the macro so that it does not display on the first summary report created:

  1. Open the macro and choose Unhide from the Window menu.

  2. Select the Formula Viewer macro and click OK.

  3. Highlight column N and choose Clear from the Edit menu.

  4. From the Window menu, choose Hide.

  5. Choose Quit. When Excel prompts to save changes to the Formula Viewer macro, choose Yes. This will permanently eliminate the financial information in column N from the macro.

The Formula Viewer macro is located on the Excel Help & Examples disk in the Macro Library folder.

KBCategory: kbother
KBSubcategory:

Additional reference words: 2.20

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.