Problem Note 33894: Excel returns an incorrect cell reference using the Analysis Toolpak
 |  |  |  |  |
When the Microsoft Analysis Toolpak is in use, you might encounter an incorrect cell reference in Excel when using the Analysis Toolpak features.
Although the incorrect cell reference is not directly caused by SAS® Add-In for Microsoft Office, disabling or unloading it can correct the problem.
See SAS Note 16844, "Missing SAS® menu in MS Excel for SAS® Add-In for Microsoft Office," for instructions to present the COM Add-Ins menu to unload SAS for the SAS Add-In for Microsoft Office.
Another workaround is to do the following with Excel open:
- Click Tools ► Data Analysis, and then immediately click Cancel.
- Then click Tools ► Data Analysis and continue normally
The problem is in the Analysis Toolpak. You are most likely to encounter the problem when it first loads, as in step 1 above. The problem does not occur on the second pass, so in step 2, the problem does not present itself in the Analysis Toolpak. You do not have to unload SAS Add-In for Microsoft Office to use this workaround.
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 | Microsoft Windows 2000 Professional | 2.1 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 2.1 | 4.3 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||