The &[Pages] function is not counting pages in a Workbook.

Copper Contributor

It appears the mysteriously the &[pages] command  is no longer able to count the number of pages in a Workbook, rather it is counting the pages of each worksheet.   Using Microsoft 365 Excel , Windows 10 PC.    Using this in the header of each page.   Example:  Page &[Page]  of &[Pages]   prints:   Page 1 of 1  rather than, Page 1 of 66 .


Your help will  be very much appreciated, as Microsoft tech support could not solve this problem for me.


Thanks for considering my dilemma.



0 Replies