Lab Export: Quick Export and PDF

Estimated reading time: 5 minutes


The Quick Export and PDF method of distribution is the simplest. The purpose of Quick Export is to build a new workbook from the current workbook and remove all the external links and Data Cell formulas so users without Interject can view the report. It’s important to note that Tabular Interject reports can be viewed immediately by users without Interject and do not need to be exported to be shared. Although Tabular reports use special report formulas, the formulas remain out of view for users without Interject, and any data pulled into the report are simply values. Outside users can view them without any modification.

If you are following the Training Labs, this report file can be found in the Report Library at Training Labs > Lab 7 Exporting Data > Lab 7.1 Quick Export and PDF.

Quick Export

Quick Export removes Data Cell formulas and external links from a workbook so users without Interject can view them.

Take the report PL Trend Report with Data Cells from the Financial Walk-through as an example. It is shown below.

Step 1: First, use the Pull Data operation to pull the report for Location 7002 and month 2002-05. Note: Ensure that the “Calculate Data Cells” is checked.

Now you have the report to distribute. However, if you send this report with data cells, people without Interject will not be able to view all the Data Cell formulas like in cell K16 below. Without Interject installed that formula will show as #NAME.

Step 2: To prevent this issue, you can use Export Book to create a new book and convert the data cell functions into regular values.

Once complete, the report will upload into a brand new workbook with fixed values instead of data cell formulas. This allows users without Interject to view the report.

Quick PDF

Exporting to PDFs from Excel has been available since Excel 2010 (and even with Excel 2007 accompanied by the download available here ). You will select this option and choose a folder in which to save the PDF. After saving, the PDF will open for review.

Step 1: Go back to the PL Trend with Data Cells from the previous section. You can again select Export Book, but this time follow up with the Quick PDF button.

Step 2: When you export to a PDF you will be required to declare a save location.

Step 3: The PDF opens in the default browser. The published file should look like the one below.

You have completed the quick exporting section. Continue on to learn about the Basics of Distribution .