Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Excel - Office 2007 raises an Exception when publishing to PDF

When running the SAS Financial Management Add-in for Microsoft Excel with Microsoft Office 2007, publishing or saving as a PDF might fail. To replicate the error follow these steps:

• Create a report in the Excel client. Ensure that the report contains at least one slicer and at least two members within that slicer.
• Select "Publish" and then "Report" from the FM Excel toolbar.
• Select "Create a new Report", enter a Name and "Static" for type. Click "Next".
• Select "PDF" for the file type. "Entire workbook" should be selected as the scope. Click "Next".
• Select at least one slicer in the next window. Click "Next".
• Select two members associated with the slicer. Click "Next".
• Select "Create a single report". Click "next".
• Select "Local folder" as the delivery method. Provide a valid folder name. Click "next".
• Select "Do not save report settings". Click "Next".
• Click "Finish" on the summary window.

	[mm/dd/yyyy hh:mm:ss] --------------- EXCEPTION REPORT ---------------

	[mm/dd/yyyy hh:mm:ss] System.ArgumentException: Value does not fall within the

	expected range.

	   at

	Microsoft.Office.Interop.Excel.WorkbookClass.ExportAsFixedFormat(XlFixedFormatType

	Type, Object Filename, Object Quality, Object IncludeDocProperties, Object

	IgnorePrintAreas, Object From, Object To, Object OpenAfterPublish, Object

	FixedFormatExtClassPtr)

	   at SASSESExcelAddIn.Publish.saveAsPDF(PublishDistribution

	publishDistribution, String& fileName, Workbook wb) in

        C:\Users\chconr\Documents\Visual Studio 2010\FM5.3_Testing\Controller\Excel\Publish.cs:line 1528

           at SASSESExcelAddIn.Publish.publishReportDetails() in

        C:\Users\chconr\Documents\Visual Studio 2010\FM5.3_Testing\Controller\Excel\Publish.cs:line 1020

        [mm/dd/yyyy hh:mm:ss] System.Runtime.InteropServices.COMException (0x800A03EC):

        Exception from HRESULT: 0x800A03EC

        at Microsoft.Office.Interop.Excel._Worksheet.Select(Object Replace)

        at SASSESExcelAddIn.Publish.publishReport() in

        C:\Users\chconr\Documents\Visual Studio 2010\FM5.3_Testing\Controller\Excel\Publish.cs:line 1770

        [mm/dd/yyyy hh:mm:ss] ----------- END OF EXCEPTION REPORT ------------

      

This failure occurs because Office2007 does not provide the functionality of saving a workbook as a PDF by default. To publish a PDF, a PDF Add-in can be easily downloaded from the MS Web site:

Operating System and Release Information