Problem Note 60133: SAS® Visual Analytics report might render incorrectly when refreshed in batch mode inside Microsoft Excel
 |  |  |  |
SAS Visual Analytics reports that are viewed inside Microsoft Excel might refresh incompletely when they are refreshed as a scheduled task. This problem is most likely to occur for complex reports that have large results. The problem occurs when the Save operation is called before the Refresh action is fully finished.
As a workaround, you can manually edit the VBS script that is created during the schedule process. The default location for the script is Documents\My SAS Files\Add-In for Microsoft Office. In the VBS file, find the following line:
workbook.Save
Just before this line, add the following line:
Wscript.sleep 10000
This change delays the Save operation for 10 seconds, which should allow enough time for the report to finish rendering.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise 32-bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 7.12 | 7.14 | 9.4 TS1M3 | 9.4 TS1M4 | ||
For large and complex SAS Visual Analytics reports, the VBS script that performs the Refresh action might call the Save operation before the report is fully rendered.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-04-12 16:23:29 |
| Date Created: | 2017-03-15 08:21:40 |