About exporting worksheets that contain page items

When you export a worksheet that contains page items, you export exactly what you see on the screen. In other words, you export data for the currently selected page item.

To export other combinations of page items, first pivot the page items and then export the modified worksheet.

If you want to export all page items, pivot the page item to the body of the worksheet so that all page items are visible on the worksheet.