Excel: Using COMPARE.XLA Generates Macro Error

 Last reviewed: November 30, 1994
Article ID: Q86685
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0
  • Microsoft Excel for OS/2, version 3.0

SUMMARY

The COMPARE.XLA (Windows and OS/2) and WORKSHEET COMPARISON (Macintosh) add- in macros included in the Microsoft Excel versions mentioned at the beginning of this article may generate a macro error when you compare two files that contain long formulas or other data.

MORE INFORMATION

COMPARE.XLA (Windows and OS/2) and WORKSHEET COMPARISON (Macintosh) are add-in macros that compare two worksheets on a cell-by-cell basis and then create a new worksheet that displays the differences between the worksheets being compared.

Listed below are the limits of cell comparison for Microsoft Excel 3.0 and 4.0.

If you exceed these limits, you will receive the macro error messages. 

Version of       Combined length of    Error message if limit is exceeded
Microsoft Excel cells being compared 
                 cannot exceed

3.0 for the      466 characters        Macro error at cell: Worksheet
Macintosh                              Comparison!B55

3.0 for Windows   212 characters       Macro error at cell:
                                       COMPARE.XLA!B53



4.0 for the      466 characters        Macro error at cell: Worksheet
Macintosh                              Comparison!B63



4.0 for Windows  476                   Macro error at cell:
                                       COMPARE.XLA!B63
                 characters

REFERENCES

"User's Guide 1," version 4.0, page 301 "User's Guide" for Windows, version 3.0, pages 695-696 "User's Guide" for the Macintosh, version 3.0, pages 691-692

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00 add in

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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.