Problem Note 52352: Formulas in Excel are not recalculated automatically when you update sheets with the EXPORT procedure and DBMS=XLSX in SAS® 9.3 and SAS® 9.4
 |  |  |  |  |
When you update an Excel spreadsheet with the EXPORT procedure in SAS 9.3 and SAS 9.4, formulas are not recalculated automatically when the file is opened in Excel.
You can force recalculations with the following key combinations in Excel:
- Alt-Ctrl-F9: Calculations in current sheet are updated
- Shift-Alt-Ctrl-F9: Calculations in all sheets are updated
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Solaris for x64 | 9.3 TS1M1 | 9.4 TS1M1 |
| Linux for x64 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Linux | 9.3 TS1M1 | 9.4 TS1M1 | ||
| HP-UX IPF | 9.3 TS1M1 | 9.4 TS1M1 | ||
| 64-bit Enabled Solaris | 9.3 TS1M1 | 9.4 TS1M1 | ||
| 64-bit Enabled HP-UX | 9.3 TS1M1 | 9.4 TS1M1 | ||
| 64-bit Enabled AIX | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows Vista for x64 | 9.3 TS1M1 | |||
| Windows Vista | 9.3 TS1M1 | |||
| Windows 7 Ultimate x64 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Professional x64 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Home Premium x64 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Enterprise x64 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Enterprise 32 bit | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows XP Professional | 9.3 TS1M1 | |||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 R2 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 | 9.3 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M1 | |||
| Microsoft® Windows® for x64 | 9.3 TS1M1 | 9.4 TS1M1 | ||
A fix for this issue for SAS/ACCESS Interface to PC Files 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G31.html#52352A fix for this issue for SAS/ACCESS Interface to PC Files 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J37.html#52352
When you update an Excel spreadsheet with the EXPORT procedure in SAS® 9.3 and SAS® 9.4, formulas are not recalculated automatically upon opening the file in Excel.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-02-27 13:33:54 |
| Date Created: | 2014-02-17 11:13:39 |