Excel: GET.DOCUMENT(64) or (65) Return Incorrect Count or #N/A

Last reviewed: November 4, 1994
Article ID: Q91629
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a

SUMMARY

The GET.DOCUMENT(64) function returns an array of row numbers corresponding to rows that are immediately below a manual or automatic page break. The GET.DOCUMENT(65) function returns an array of column numbers corresponding to columns that are immediately to the right of a manual or automatic page break. In version 4.0 of Microsoft Excel for Windows, these automatic page breaks are determined based on the page orientation specified in the Windows Printer Setup dialog box instead of the page orientation specified in the Microsoft Excel Page Setup dialog box.

MORE INFORMATION

If the orientation option for your worksheet is set to landscape in the Microsoft Excel Page Setup dialog box but the Portrait option is selected in the Windows Printer Setup dialog box, the GET.DOCUMENT(64) or (65) functions return an array of portrait page breaks instead of an array of landscape page breaks. This situation applies only to automatic page breaks.

Note: If there are not enough rows or columns of data to fill one or more pages, the GET.DOCUMENT(64) or (65) functions return the "no value is available" (#N/A) error value. This number of pages is determined by the page orientation specified in the Windows Printer Setup dialog box instead of the page orientation specified in the Microsoft Excel Page Setup dialog box.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, pages 196-199


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.0 4.00 GET.DOCUMENT get document set up


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.