Usage Note 17930: CDA Table cells do not update unless calculation set to "automatic" in Microsoft Excel
There is a change in behavior with how values in CDA tables are refreshed in SAS® Financial Management release 4.2.
If a CDA table has been created using the SAS Financial Management Add-in for Microsoft Excel and data in the model are impacted (via a Data entry table, by posting adjustments or from loading data from the DDS), the values in the CDA table will only refresh if the Calculation method is set to "automatic" in Excel. The Calculation method can be set by selecting Tools > Options > Calculation from the menu bar in Excel.
In SAS Financial Management release 4.1, CDA table values would update if you selected SAS Solutions > View > Refresh All from the Excel menu bar or selected the refresh "lighting bolt" icon on the Excel toolbar. Selecting Refresh All or the lightning bolt icon will not update CDA table values in SAS Financial Management release 4.2.
Operating System and Release Information
| SAS System | SAS Financial Management | Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 4.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 4.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Advanced Server | 4.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 4.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 4.2 | | 9.1 TS1M3 SP4 | |
*
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.
| Type: | Usage Note |
| Priority: | medium |
| Date Modified: | 2010-06-16 14:23:52 |
| Date Created: | 2006-06-23 11:13:27 |
