Excel Sheet Not Showing All Pages

I have saved a report to Excel, but it is only showing the information from the first five pages.  How do I see it all?

Solution

If all of the information is not available to view, either as excel or PDF, then from the preview screen open the Config box from the top tool bar.

From there, under the Controls tab, ensure the Max. pages to search is set to -1 to allow all pages to be seen.