Microsoft KB Archive/81565

{|
 * width="100%"|

Excel: Subscription to Large Edition Displays #N/A

 * }

-

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.