Excel: Flat File Add-In Gives Incorrect Percent Complete

Last reviewed: November 30, 1994
Article ID: Q76597
The information in this article applies to:
  • Microsoft Excel for Windows, version 3.0
  • Microsoft Excel for the Macintosh, version 3.0

Summary:

If you use the Flat File Add-in macro to export more than 6400 cells, the status bar displays an incorrect percentage complete. Percentages increase by increments of 100 percent and the final value is well over 100 percent. Even though these percentages are incorrect, the data exports correctly, and completely.

More Information:

This is due to the Flat File Add-in macro using the COUNTA() function to count the number of cells in the range to be exported, which is limited to approximately 6400 cells, the maximum size of an array.

You can place the following statement in cell B33 of the Add-in macro, or cell B31 in Microsoft Excel for Windows to replace the COUNTA() function:

   =ROWS(SELECTION())*COLUMNS(SELECTION())

This formula allows the range of cells being exported to exceed 6400 and still return the correct percentage completed in the status bar.

For more information on Add-in macros for Microsoft Excel, see Appendix B in the "Microsoft Excel User's Guide," version 3.0.


KBCategory: kbother
KBSubcategory:

Additional reference words: flatfile flatfile.xla 3.00


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.