Excel: Subscription to Large Edition Displays #N/A

Last reviewed: November 4, 1994
Article ID: Q81565

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

SUMMARY

The size of a published edition to which Microsoft Excel can subscribe is limited by the maximum size of an Excel array. Therefore, Excel cannot subscribe to editions that contain more than 6,551 cells worth of information. This is true even if the subscribing area inside Excel is only a few cells in size.

If the edition is too large, all cells within the subscribing area return #N/A.

MORE INFORMATION

Excel allocates memory for an entire publication, even if it will display only a part of it.

Publish and Subscribe are features of Apple Macintosh System 7.0.

REFERENCES

"Microsoft Excel User's Guide," for the Macintosh, version 3.0, pages 317-321

KBCategory: kbusage
KBSubcategory:
Additional reference words: 3.00 4.00 5.00 macxl

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