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 would be 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.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Add-in for Microsoft Office | Microsoft Windows 2000 Professional | 2.1 | |
| Microsoft Windows XP Professional | 2.1 | |
*
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: | Problem Note |
| Priority: | medium |
| Date Modified: | 2008-12-09 14:40:28 |
| Date Created: | 2008-11-12 09:16:39 |
