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.