Excel: Subscription to Large Edition Displays #N/A

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

Additional query words: 4.00 macxl

Keywords :
Version :
Platform :
Issue type :