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
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
| SAS System | SAS Financial Management | Microsoft Windows 8 Enterprise x64 | 5.4_M1 | | | |
| Microsoft Windows 8 Pro x64 | 5.4_M1 | | | |
| Microsoft Windows 8.1 Enterprise x64 | 5.4_M1 | | | |
| Microsoft Windows 8.1 Pro x64 | 5.4_M1 | | | |
| Windows 7 Enterprise x64 | 5.4_M1 | | | |
| Windows 7 Home Premium x64 | 5.4_M1 | | | |
| Windows 7 Professional x64 | 5.4_M1 | | | |
| Windows 7 Ultimate x64 | 5.4_M1 | | | |
| Microsoft® Windows® for x64 | 5.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.
Cell Data Access Reports (CDA) resolve to #NUM! when published from the 64-bit version of Microsoft Excel.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-05-25 08:54:57 |
| Date Created: | 2016-10-19 11:56:13 |
