SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 16980: Microsoft Excel generates extra prompts when filtering on large data sets with SAS® Add-In for Microsoft Office

DetailsHotfixAboutRate It

When you filter large amounts of SAS data in the SAS Add-In for Microsoft Office, the following prompt might appear:

Microsoft Excel is waiting for another application to complete an OLE action.

Excel generates the prompt because when you filter very large data sets, the process runs longer than Excel expects. The prompt does not interfere with the filtering process, which continues to run.

To get rid of the prompt, click OK.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Add-in for Microsoft OfficeMicrosoft Windows 2000 Advanced Server1.30
Microsoft Windows 2000 Datacenter Server1.30
Microsoft Windows 2000 Server1.30
Microsoft Windows 2000 Professional1.30
Microsoft Windows NT Workstation1.30
Microsoft Windows XP Professional1.304.39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition1.304.39.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition1.304.39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition1.304.39.3 TS1M0
* 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.