SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59181: SAS® Financial Management Add-in for Microsoft Excel produces a #NUM! error when publishing from the 64-bit version of Microsoft Excel

DetailsHotfixAboutRate It

When publishing a SAS Financial Management Cell Data Access (CDA) report, you might encounter #NUM! errors in the place of some expected values in the published report.

This problem occurs under the following conditions:

  • You publish the CDA report as a static Microsoft Excel Binary Workbook.
  • The entire workbook is scoped from the 64-bit version of Microsoft Excel 2013.

To obtain a fix for this issue, contact SAS Technical Support.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Financial ManagementMicrosoft Windows 8 Enterprise x645.4_M1
Microsoft Windows 8 Pro x645.4_M1
Microsoft Windows 8.1 Enterprise x645.4_M1
Microsoft Windows 8.1 Pro x645.4_M1
Windows 7 Enterprise x645.4_M1
Windows 7 Home Premium x645.4_M1
Windows 7 Professional x645.4_M1
Windows 7 Ultimate x645.4_M1
Microsoft® Windows® for x645.5
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.