SUPPORT / SAMPLES & SAS NOTES
Problem Note 38220: SAS® Information Maps with filters do not migrate properly from the SAS® Add-In for Microsoft Office 2.1 to the SAS Add-In for Microsoft Office 4.2
 |  |  |  |  |
When you migrate a Microsoft Excel file that contains an information map with a filter, the Migration Wizard does not give you the option to remap the server information. As a result, when you attempt to refresh the content in version 4.2, the old server information is used and you receive an error.
As a workaround, perform these steps:
- Open the workbook in version 2.1.
- Remove the filter from the information map.
- Do the migration.
- Open the workbook in version 4.2.
- Reapply the filter to the information map.
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||