Database Reference
In-Depth Information
Figure 15-33.
Configuring the “Entire workbook” option
After clicking OK to close the dialog box, click the Publish button to save your reports to the PDF format.
Acrobat Reader immediately opens and displays your report. If, for some reason, your report is not displayed,
navigate to your PDF file and open it yourself. Either way, at this point you will be able to review how your report
looks in PDF.
Do not be surprised if the PDF format looks different from the original Excel format. Although Microsoft
has tried to make this process as painless as possible, expect to make adjustments and then save and view the
PDF file repeatedly until you get the look and feel that you want. For example, you may find that having the chart
below the pivot table looks better in the PDF file (Figure
15-34
).
■
we do not recommend telling your boss you will have that Excel report for them in the next ten minutes!
Excel reports are easy to make, but it can take quite some time to make them professional looking enough for
publication. Plan accordingly!
Tip
