SYMPTOMS
When you make a Visual Basic for Applications (VBA) call to
a property of the
TableRange object in Excel 2000, you may receive the following error
message:
-2147417848 Method 'Style' of object 'Range'
failed
You may also receive the following error message:
Run-time error '1004':
Unable to get the TableRange2
property of the PivotTable Class
RESOLUTION
A
supported fix is now available from Microsoft, but it is only intended to
correct the problem that is described in this article. Apply it only to systems
that are experiencing this specific problem.
To resolve this problem
immediately, download the fix by clicking the download link later in this
article or contact Microsoft Product Support Services to obtain the fix. For a
complete list of Microsoft Product Support Services phone numbers and
information about support costs, visit the following Microsoft Web site:
Note In special cases, charges that are ordinarily incurred for
support calls may be canceled if a Microsoft Support Professional determines
that a specific update will resolve your problem. The usual support costs will
apply to additional support questions and issues that do not qualify for the
specific update in question.
The English version of this
fix has the file attributes (or later) that are listed in the following table.
The dates and times for these files are listed in coordinated universal time
(UTC). When you view the file information, it is converted to local time. To
find the difference between UTC and local time, use the
Time
Zone tab in the Date and Time tool in Control Panel.
Date Time Size File name
------------------------------------------------
01-Mar-2003 06:32 1,697,120 Excel.msp
01-Mar-2003 07:32 4,422,240 Excelff.msp
01-Mar-2003 07:03 1,746,796 Excelop.msp
After the hotfix is installed, the following files will have the
listed attributes or later:
Date Time Version Size File name
-------------------------------------------------------
28-Feb-2003 05:55 9.0.0.7427 7,163,949 Excel.exe
This fix is
a post-Office 2000 Service Pack 3 (SP-3) fix. To install the fix, you must have
Office 2000 SP-3 installed. For additional information about Office 2000 SP-3,
click the following article number to see the article in the Microsoft
Knowledge Base:
326585 OFF2000: Overview of Office 2000 Service Pack 3
Additionally, you may have to install Windows Installer 2.0 to
install this fix. For additional information about the Windows Installer
requirement for post-Office 2000 SP-3 fixes, click the following article number
to see the article in the Microsoft Knowledge Base:
811002 OFF2000: Office 2000 Updates and Patches Released After November 2002 May Require Windows Installer 2.0