Excel 2000 articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2000 that have been released in January 2007. The list is daily updated.

316027 Linked Excel charts in Office documents do not update after you change MUI Language Q316027 KB316027 January 31, 2007
314810 Error message during Office 2000 or Office XP installation: "Error 1335 - Cannot Copy Cab File Office1.cab" Q314810 KB314810 January 31, 2007
313454 How to clear the Most Recently Used list (MRU) list in Office programs Q313454 KB313454 January 31, 2007
312596 Windows Installer starts each time that a new user starts an Office 2000 program Q312596 KB312596 January 31, 2007
312595 You receive a "Visual Basic compile error in hidden module" error message when you start or quit an Office 2000 program Q312595 KB312595 January 31, 2007
310393 OFF2000: French Office 2000 Programs Do Not Start on Computer Running Windows 98 (English) Q310393 KB310393 January 31, 2007
309671 XL2000: SR-1 Stops Responding When You Open a File After an Incomplete Save Q309671 KB309671 January 31, 2007
308138 OFF2000: Cannot Save a Word or Excel Document to a Web Site That Was Opened from Within Internet Explorer Q308138 KB308138 January 31, 2007
307818 OFF: Error Message When You Click a Hyperlink in an Office Document Q307818 KB307818 January 31, 2007
307812 Troubleshooting navigation issues in Microsoft Excel Q307812 KB307812 January 31, 2007
307653 You receive an "Error creating process (msiexec.exe /i msicuu.msi)" error message when you use the Windows Installer Cleanup utility Q307653 KB307653 January 31, 2007
305567 Decimal point or trailing zeros unexpectedly appear in number in Excel Q305567 KB305567 January 31, 2007
305504 OFF2000: Internal Error 2735 Referencing Out128.dll When You Install Office 2000 Q305504 KB305504 January 31, 2007
305503 OFF2000: Error Message When You Try to Install Office: Internal Error 2263 Q305503 KB305503 January 31, 2007
305498 "Not enough memory" error message when you start Word 2000 or Excel 2000 Q305498 KB305498 January 31, 2007
304494 How to use Visual Basic for Applications in Excel Q304494 KB304494 January 31, 2007
304483 OFF2000: Error Message When You Try to Start an Office Program: A Fatal Exception 0D Has Occurred at fff000fff Q304483 KB304483 January 31, 2007
303263 Gridlines missing from printed worksheet even though printing of gridlines is turned on Q303263 KB303263 January 31, 2007
302906 OFF2000: Office 2000 Migration Runs for Each User on Windows XP Q302906 KB302906 January 31, 2007
302877 OFF2000: Error Message: This Program Must Be Installed to Run Q302877 KB302877 January 31, 2007
302777 You receive an "Error 1603 Error_Install_Failure" error message when you try to use a feature that is not installed in PowerPoint 2000 Q302777 KB302777 January 31, 2007
302753 Office 2000 programs can browse restricted drives Q302753 KB302753 January 31, 2007
302472 OFF2000: "Internal Error 2103" Error Message Is Displayed During Setup Q302472 KB302472 January 31, 2007
302382 Money: How to Export a Money Report to an Excel Worksheet Q302382 KB302382 January 31, 2007
301418 OLAP cube data is returned alphabetically in a PivotTable report in Excel Q301418 KB301418 January 31, 2007
300276 OFF2000: SR-1 Update Does Not Update Windows Installer or CD-2 Q300276 KB300276 January 31, 2007
300257 OFF2000: Invalid Page Fault in User.exe When You Try to Register Product Q300257 KB300257 January 31, 2007
299972 Office Server Extensions Installation Fails When Office SR-1 Is Already Installed Q299972 KB299972 January 31, 2007
299779 OFF2000: Error Message During Installation: Installer Terminated Prematurely Q299779 KB299779 January 31, 2007
299777 "Error 2908. Could not register component [2]" error message when you install Office 2000 Q299777 KB299777 January 31, 2007
299775 OFF2000: "Internal Error 2352" Error Message When You Attempt to Install Office Q299775 KB299775 January 31, 2007
299702 OFF2000: Windows Installer Stops Responding When You Attempt to Upgrade from Office 97 to Office 2000 Q299702 KB299702 January 31, 2007
299661 "The file 'D:\DATA1.MSI' is not a valid installation package for the product Microsoft Office 2000 SR-1 Premium" error message that indicates incorrect CD-ROM is inserted when you install or repair Office 2000 Q299661 KB299661 January 31, 2007
299608 "Error 1911. Could not register type library for" error message when you run the Office 2000 Setup program Q299608 KB299608 January 31, 2007
297883 XL2000: You Can See Other Users' Printers in a Terminal Server Session Q297883 KB297883 January 31, 2007
296665 XL2000: Data Labels Do Not Retain Formatting Q296665 KB296665 January 31, 2007
296175 "Error 1310. Error writing to file" error message when you install Office 2000 Q296175 KB296175 January 31, 2007
296067 How to use msiexec.exe and the globally unique identifier (GUID) of the product to remove suite or stand-alone Office 2000 programs Q296067 KB296067 January 31, 2007
296055 "Cannot find the file" error message when you open Excel files from outside of Excel Q296055 KB296055 January 31, 2007
295685 OFF2000: Excel 2000 SR-1 Eurotool Add-in Update - Admin Q295685 KB295685 January 31, 2007
294975 BUG: You receive a "This installation package could not be opened" error message when you run Office 2000 Setup Q294975 KB294975 January 31, 2007
294109 Shapes in resized embedded Visio object are not visible in Visio 2002 Q294109 KB294109 January 31, 2007
292499 Image does not appear in thumbnail view after removing Office Q292499 KB292499 January 31, 2007
292464 OFF2000: Invalid Page Fault After You Use Desktop Themes Control Panel Q292464 KB292464 January 31, 2007
292264 You cannot open a password-protected workbook if you forget or lose the password Q292264 KB292264 January 31, 2007
292032 OFF2000: "Installer Terminated Prematurely" Error Message When You Use ! Logging Option Q292032 KB292032 January 31, 2007
291912 You receive a virus warning message when you click hyperlink to a program in Office 2002 or Office 2000 Q291912 KB291912 January 31, 2007
291074 Default toolbars and toolbar buttons seen instead of customizations in Excel Q291074 KB291074 January 31, 2007
290570 Embedded charts that contain text boxes in Excel 2000 do not behave as expected after they are edited in PowerPoint 2000 and in PowerPoint 2002 Q290570 KB290570 January 31, 2007
290359 How to remove leading space for values converted to strings Q290359 KB290359 January 31, 2007
289006 You may receive an error message or the Publisher icon becomes generic or no longer appears in the Start menu when you start an Office program Q289006 KB289006 January 31, 2007
288839 XL: Exported Comma Separated File Ignores Regional Settings Q288839 KB288839 January 31, 2007
287484 How to download and install an administrative update available for the Access 2000 and SQL Server 2000 Readiness Update Q287484 KB287484 January 31, 2007
896309 The bullet that is located at the start of the tracer arrows will randomly appear and disappear when you scroll through an Excel worksheet window Q896309 KB896309 January 30, 2007
821404 You cannot send e-mail messages from Word, PowerPoint, and Excel Q821404 KB821404 January 30, 2007
316653 PRB: Error Using WithEvents or Delegates to Handle Excel Events from Visual Basic .NET or Visual C# .NET Q316653 KB316653 January 30, 2007
285336 OFF2000: Administrative Update Available for Microsoft Office 2000 Web Client Security Q285336 KB285336 January 29, 2007
282855 How to create and use one-input data tables in Microsoft Excel Q282855 KB282855 January 29, 2007
281848 "ActiveX component can't create object" error message when you run code that calls the Common Dialog Control (Comdlg32.ocx) Q281848 KB281848 January 29, 2007
280711 OFF2000: Office Installation Program Starts When You Use Camera in USB Port Q280711 KB280711 January 29, 2007
280680 Cannot follow hyperlink to Office document Q280680 KB280680 January 29, 2007
279721 How to use Dynamic Data Exchange (DDE) with Word and Excel from Visual C++ Q279721 KB279721 January 29, 2007
279299 How to troubleshoot the installation of Office 2000 SP2 by using the log file Q279299 KB279299 January 29, 2007
279177 "Error 1931" When You Run Detect and Repair For Office 2000 Q279177 KB279177 January 29, 2007
278949 PRB: Range::GetApplication Method Returns an Incorrect Interface Pointer Q278949 KB278949 January 29, 2007
278238 You receive a "The feature you are trying to use is on a CD-ROM or other removable disk that is not available" error message when you apply an update for an Office 2000 installation Q278238 KB278238 January 29, 2007
277686 OFF2000: How to Force the Clipboard Toolbar to Remain Docked Q277686 KB277686 January 29, 2007
275869 Error 1711: "An error occurred while writing installation information to disk" Q275869 KB275869 January 29, 2007
274041 FIX: You receive an "Error 1931. The Windows Installer service cannot update the system file" error message when you run Detect and Repair for Office 2000 Q274041 KB274041 January 29, 2007
273674 OFF2000: "Windows Cannot Find <File Name>" When You Start Program Q273674 KB273674 January 29, 2007
272729 How to import data with more than 256 fields or columns into Excel Q272729 KB272729 January 29, 2007
272066 Compile error in hidden module Tbrun97.xls in Excel Q272066 KB272066 January 29, 2007
271856 Hyperlink does not work when pasted or imported Q271856 KB271856 January 29, 2007
271672 OFF2000: "Deploying Microsoft Office 2000: Notes from the Field" Book Online Q271672 KB271672 January 29, 2007
270862 You receive an "OS Loader V4.01 Disk I/O Error Stats=00000001" error message when you install Office 2000 Q270862 KB270862 January 27, 2007
270068 OFF2000: Administrative Update Available for Microsoft Office 2000 HTML Data Security Q270068 KB270068 January 27, 2007
269880 OFF2000: Microsoft Office 2000 HTML Data Security Update Available Q269880 KB269880 January 27, 2007
269581 OFF2000: How to Delete, Print, or Rename a File from Within an Office Program Q269581 KB269581 January 27, 2007
269340 OFF2000: How to Customize Add/Remove Functionality Q269340 KB269340 January 27, 2007
269276 You receive a "This application must be installed to run" error message when you start an Office 2000 program after you remove Windows 2000 SP1 Q269276 KB269276 January 27, 2007
269267 XL2000: Administrative Update Available for the Excel 2000 SR-1 REGISTER.ID Function Vulnerability Q269267 KB269267 January 27, 2007
269168 How to recognize the difference among Excel 97 files, Excel 2000 files, and Excel 2002 files by using Visual C++ 6.0 Q269168 KB269168 January 27, 2007
268790 OFF2000: Error Message When You Apply CDO Update to Administrative Installation Q268790 KB268790 January 27, 2007
268719 OFF2000: How to Update an Administrative Installation with the Outlook CDO Security Update Q268719 KB268719 January 27, 2007
268560 OFF2000: Cannot Insert Graphic Image from Novell Server When Path Has Multiple Long Folder Names Q268560 KB268560 January 27, 2007
268465 OFF2000: Error Message "Help Requires Microsoft Internet Explorer 3.0 or Greater" When You Start Help Q268465 KB268465 January 27, 2007
268355 OFF2000: Error Message: "Help Requires Microsoft Internet Explorer 3.0 or Greater" When You Start Help Q268355 KB268355 January 27, 2007
268139 OFF2000: Default Installation States for "Install Now" Installations Q268139 KB268139 January 27, 2007
268007 How to sort more than three columns in Excel Q268007 KB268007 January 27, 2007
267835 OFF2000: "Another Version of This Product Is Already Installed" Error Message When You Update Network Client Q267835 KB267835 January 27, 2007
267248 OFF2000: Error 2928 When You Install Office 2000 with Additional Sources Specified Q267248 KB267248 January 27, 2007
266318 How to retrieve the name of an Office document that contains an MFC ActiveX control Q266318 KB266318 January 27, 2007
266069 "The feature you are trying to use is on a network resource that is unavailable" error message when you try to repair or reinstall Office 2000 Q266069 KB266069 January 27, 2007
265361 XL: Excel Does Not Run on Multiple Processors Q265361 KB265361 January 27, 2007
264709 OFF2000: Characters Are Displayed Upside Down When You Insert EMF Q264709 KB264709 January 27, 2007
264625 How to install or repair individual features of Office 2000 Q264625 KB264625 January 27, 2007
264596 OFF2000: How to Install Office on Windows NT 4.0 Q264596 KB264596 January 27, 2007
263640 OFF2000: Only One Copy of Ouactrl.ocx File Is Updated by UA Control Security Update Q263640 KB263640 January 27, 2007
263561 INFO: Non-BDE Paradox and dBase ISAM Drivers Q263561 KB263561 January 27, 2007
263213 INFO: Excel May Change the Precision Mode of the Floating-Point Control Word Q263213 KB263213 January 27, 2007
263210 You lose some Office 2000 functionality after you apply the Outlook e-mail security update Q263210 KB263210 January 27, 2007
263134 OFF2000: How to Update an Administrative Installation with the UA Control Security Update Q263134 KB263134 January 27, 2007
262767 Update available for Office 2000 UA Control vulnerability Q262767 KB262767 January 27, 2007
262113 XL2000: Labels on XY Scatter Graphs Disappear in Print Preview Q262113 KB262113 January 27, 2007
261997 How To Obtain the Window Handle for an Office Automation Server with MFC Q261997 KB261997 January 27, 2007
260899 OFF2000: AutoCorrect List May Not Be Migrated from Earlier Version of Office Q260899 KB260899 January 27, 2007
260893 Works: Spreadsheet Functions Imported from Excel 2000 to Works Q260893 KB260893 January 27, 2007
260825 OFF2000: Desktop May Not Be Displayed Correctly on Restart After Setup Q260825 KB260825 January 27, 2007
260410 Microsoft Office 2000 automation Help file is available in the Download Center Q260410 KB260410 January 27, 2007
259137 How to determine whether a selected cell in an Excel worksheet is in a specified defined range by using a Visual Basic macro Q259137 KB259137 January 27, 2007
258847 "The feature you are trying to use is on a network resource that is unavailable" or "Error 1706" error message when you use a feature that is set to Installed on First Use Q258847 KB258847 January 27, 2007
258781 You receive an error message when you try to open multiple documents in Excel Q258781 KB258781 January 27, 2007
258297 You receive an error message when you run the Office 2000 file and Registry Eraser Utility to remove Office 2000 Q258297 KB258297 January 27, 2007
258197 You receive an "Unable to run this command" error message when you try to start Office 2000 programs Q258197 KB258197 January 27, 2007
257593 Office 2000 programs quit immediately on Windows 2000 when you are logged on as user Q257593 KB257593 January 27, 2007
257464 Hyperlinks in an e-mail message do not work in Office 2000 or in Office 2002 programs Q257464 KB257464 January 27, 2007
257456 OFF2000: Cannot Suspend Computer with Windows 2000 Offline Files Open Q257456 KB257456 January 27, 2007
257451 XL2000: Formulas Not Adjusted Automatically When You Enter New Data Q257451 KB257451 January 27, 2007
255085 Using the Discussion Feature in Internet Explorer Q255085 KB255085 January 27, 2007
254898 OFF2000: No Documentation for Office 2000 Setup Command-Line Options /noreboot and NOOLEAUT32CHECK=YES Q254898 KB254898 January 27, 2007
254890 OFF2000: Setup Does Not Continue When You Update to SR-1 from an Administrative Installation Q254890 KB254890 January 27, 2007
254884 OFF2000: Error Message When You Run Office Setup: IE5WZD Caused an Invalid Page Fault in Module MSSIP32.DLL Q254884 KB254884 January 27, 2007
254880 You receive an "Error opening installation log file" error message when you use /L in a command line to run Office 2000 Setup Q254880 KB254880 January 27, 2007
254852 OFF2000: Cannot Add New Document As Hyperlink to Office 2000 Documents After Upgrade to Windows 2000 from Windows 98 Q254852 KB254852 January 27, 2007
254842 OFF2000: Setup Detects Files As Present When They Are Actually Not Installed Q254842 KB254842 January 27, 2007
254841 You receive an "Internal Error 2755" error message when you try to install Office 2000 from a remote Windows Terminal Server client Q254841 KB254841 January 27, 2007
254837 OFF2000: "You Have Limited Privileges..." Error with Managed Deployment on Windows 2000 Q254837 KB254837 January 27, 2007
254836 OFF2000: Error Message: Machine Debug Manager: The Service Could Not Be Uninstalled Q254836 KB254836 January 27, 2007
254008 Gantt Chart Sample Add-In is available for download Q254008 KB254008 January 27, 2007
254006 INFO: Access Data Retrieval Sample Add-In Available for Download Q254006 KB254006 January 27, 2007
253768 You receive an "Error 1706. No valid source could be found for product Microsoft Office 2000 Premium" error message when you run Office 2000 Setup Q253768 KB253768 January 27, 2007
250525 OFF2000: Error Message: "Installer Terminated Prematurely" When You Try to Install Office Q250525 KB250525 January 27, 2007
249952 OFF2000: Create New Folder in Save As Dialog Box Is Not Available When You Save to My Network Places Q249952 KB249952 January 27, 2007
249946 OFF2000: Office Programs Ignore System Policy to Hide Places Bar Q249946 KB249946 January 27, 2007
249945 OFF2000: Office Programs Ignore System Policy to Hide the Back Button Q249945 KB249945 January 27, 2007
249943 OFF2000: Error Message When You Perform a Search on Windows 2000 Q249943 KB249943 January 27, 2007
249929 OFF2000: Error Installing Office Although You Have Administrative Permissions Q249929 KB249929 January 27, 2007
248861 OFF2000: Program Stops Responding When You Close a File Without Saving Q248861 KB248861 January 27, 2007
248849 "Advanced INF install failure. Reason: Access is denied" error message when you install Office 2000 Q248849 KB248849 January 27, 2007
248648 OFF2000: Arial Unicode Font Is Not Available in Office Setup Q248648 KB248648 January 27, 2007
247684 How to remove Office 2000 CD2 Q247684 KB247684 January 25, 2007
247366 OFF2000: Error 1324 When You Run Setup on Windows NT 4.0 Q247366 KB247366 January 25, 2007
246093 OFF2000: Windows Installer Breaks Access 95 File Association Q246093 KB246093 January 25, 2007
245113 OFF2000: MSDN DVD Not Recognized When You Apply the Office 2000 ODBC Vulnerability Update Q245113 KB245113 January 25, 2007
245088 OFF2000: MSDN CD Not Recognized When You Apply the Office 2000 ODBC Vulnerability Update Q245088 KB245088 January 25, 2007
244421 Supported installation methods for deploying Microsoft Office Q244421 KB244421 January 25, 2007
244021 "The feature you are trying to use is on a CD-ROM or other removable disk that is not available" error message when you change the installation state in Office 2000 Q244021 KB244021 January 25, 2007
243906 OFF2000: Setup Requires Disk Space on Installation Source Q243906 KB243906 January 25, 2007
243579 You receive an error message in a program that interacts with Word 2000 when Norton AntiVirus or SystemWorks is installed on your computer Q243579 KB243579 January 25, 2007
243495 The Calculate message may remain in the status bar when you enter formulas that include cell references Q243495 KB243495 January 25, 2007
243400 OFF2000: How to Update an Administrative Installation with ODBC Vulnerability Update Q243400 KB243400 January 25, 2007
243253 OFF2000: How to Manipulate the Feature Tree by Using the Keyboard Q243253 KB243253 January 25, 2007
243180 OFF2000: How to Get Bookshelf Basics Support in Office 2000 Q243180 KB243180 January 25, 2007
243016 Some features do not appear in the Microsoft Office 2000: Selecting Features dialog box when you install Office 2000 Q243016 KB243016 January 25, 2007
242237 Worksheet may not recalculate completely when you repeatedly press F9 Q242237 KB242237 January 25, 2007
241861 BUG: ATL Control in Office Document Prevents Another Control's Events from Working Q241861 KB241861 January 25, 2007
241056 OFF2000: "A Newer Version of DCOM95 Had Been Installed..." Message During Setup on Windows 95 Q241056 KB241056 January 25, 2007
240829 XL: Parentheses Not Displayed in Number and Currency Format Q240829 KB240829 January 25, 2007
240335 You receive an "Internal error 2336" error message that is caused by possible file damage when you install Office 2000 Q240335 KB240335 January 25, 2007
240324 Setup prompts for CD when you want to use or add a feature to Office 2000 Setup even if the CD is in the drive Q240324 KB240324 January 25, 2007
240008 Works Suite: Works Prompts You to Insert Microsoft Word 2000 Compact Disc Q240008 KB240008 January 25, 2007
238732 OFF2000: "A Newer Version of DCOM95 Had Been Installed" Message During Quiet Mode Setup Q238732 KB238732 January 24, 2007
238387 You receive installation-related error messages when you start Office 2000 programs if User Profiles are enabled and the Start menu is shared Q238387 KB238387 January 24, 2007
238319 You may receive an "Installation ended prematurely because of an error" error message when you run Office 2000 Setup and Setup cannot find the IE5 folder Q238319 KB238319 January 24, 2007
238251 How to Install Windows Messaging After You Remove Outlook 2000 or Office 2000 from Windows 95 Q238251 KB238251 January 24, 2007
238228 How to build an Office 2000 COM add-in in Visual Basic Q238228 KB238228 January 24, 2007
238133 How To Write a DDEML Server for Excel and Use it with NetDDE Q238133 KB238133 January 24, 2007
238122 How to install Office 2000 or Office XP on a computer that is running Windows Millennium Edition, Windows 95, or Windows 98 with User Profiles and without User Profiles Q238122 KB238122 January 24, 2007
237915 You receive an "Installing this product requires the Windows Installer" or an "Error 1324" error message when you run Office 2000 Setup or install Windows Installer Q237915 KB237915 January 24, 2007
237839 OFF2000: List of Files Installed When You Insert the Office CD (AutoRun) Q237839 KB237839 January 24, 2007
237741 OFF2000: Setup Repeatedly Prompts to Restart After Updating Windows Installer Q237741 KB237741 January 24, 2007
237578 You receive "Internal Error" error messages when you run Office 2000 Setup on Windows NT or Windows 2000 Q237578 KB237578 January 24, 2007
237294 You receive an "Error 1904. Module <path & file name> failed to register" error message when you run Office 2000 Setup Q237294 KB237294 January 24, 2007
236905 OFF2000: How to Install Office 2000 on a Dual-Boot System Q236905 KB236905 January 24, 2007
236893 OFF2000: Setup Does Not Display Any Interactive Dialog Boxes Q236893 KB236893 January 24, 2007
236872 You receive an "I/O Error" or the subfolders are displayed as question marks or squares in Office programs Q236872 KB236872 January 24, 2007
236597 You receive a "This installation package could not be opened" error message when you run Office 2000 Setup Q236597 KB236597 January 24, 2007
236590 You receive a "Required registry information is missing and this application cannot run" error message when you start an Office 2000 program Q236590 KB236590 January 24, 2007
236588 BUG: Prompt for user information and CD Key when you start an Office 2000 program Q236588 KB236588 January 24, 2007
236053 OFF2000: Internal Error 2894 During Office or Works Installation Q236053 KB236053 January 24, 2007
236009 OFF2000: Collaboration: Cannot Connect to All Computers During Online Meeting Q236009 KB236009 January 24, 2007
235706 OFF2000: Internet Explorer 5 Not Removed When Office Is Removed Q235706 KB235706 January 24, 2007
235603 Description of the Office 2000 Macedonian (FYROM) Update Q235603 KB235603 January 24, 2007
235438 OFF2000: AutoRun Actions Are Suppressed After Office Is Installed Q235438 KB235438 January 24, 2007
235242 You receive an "Error 1913. Could not update the ini file WIN.INI" error message when you install Office 2000 Q235242 KB235242 January 24, 2007
234804 You receive no prompts when you install an administrative installation of an Office 2000 family product Q234804 KB234804 January 24, 2007
234700 Differences between OLAP and non-OLAP PivotTables in Excel Q234700 KB234700 January 24, 2007
234688 OFF2000: Web Publishing Wizard Files Cannot Be Found During Setup Q234688 KB234688 January 24, 2007
234435 OFF2000: Utility to Repair Internal Error 2343 Available Q234435 KB234435 January 24, 2007
234356 OFF2000: Internet Explorer 5 Not Installed When Using the /j Switch Q234356 KB234356 January 24, 2007
234041 OFF2000: Error Message: "This Installation Is Forbidden by System Policy ..." Running Setup Q234041 KB234041 January 24, 2007
234036 OFF2000: How to Make the Browse Button Unavailable When the Installer Can't Find the Source Files Q234036 KB234036 January 24, 2007
233496 OFF2000: Earlier Office Versions Removed with Advertised Installation Q233496 KB233496 January 24, 2007
233273 OFF2000: List of Settings Migrated from Earlier Versions of Office Q233273 KB233273 January 24, 2007
233119 OFF2000: How to Automatically Reboot After the First Portion of Setup Q233119 KB233119 January 24, 2007
232955 OFF2000: Running Setup with /ju Switch Advertises Office for All Users Q232955 KB232955 January 24, 2007
232866 The whole Excel workbook may be pasted when you paste only the copied cells into another program Q232866 KB232866 January 24, 2007
231946 OFF2000: How to Add/Remove a Single Office Program or Component Q231946 KB231946 January 24, 2007
231614 How To Automate Excel to Create a New Workbook from Delphi Q231614 KB231614 January 24, 2007
230905 OFF2000: "Unexpected Critical Error: Can't Start Program" When You Install Office 2000 Q230905 KB230905 January 24, 2007
230904 OFF2000: Incorrect Locations for Ofread9.txt in the Readme.doc File Q230904 KB230904 January 24, 2007
230879 OFF2000: Error Message Log File Always Contains "Internal Error 2898: Please Contact Product Support for Assistance" Q230879 KB230879 January 24, 2007
230843 OFF2000: Missing Shortcut Error on Startup With Run from CD/Network Installation Q230843 KB230843 January 24, 2007
230678 OFF2000: Previous Version of Outlook Removed Unexpectedly Q230678 KB230678 January 24, 2007
229457 OFF2000: Error Installing Office on Windows NT with Internet Explorer 2.0 Q229457 KB229457 January 24, 2007
229451 OFF2000: Removing Office Removes User-modified Files Q229451 KB229451 January 24, 2007
229410 OFF2000: Cannot Open Binder Documents After Installing Office 2000 Q229410 KB229410 January 24, 2007
229386 OFF2000: "...setup completed successfully" Message Does Not Appear at the End of Setup Q229386 KB229386 January 24, 2007
229381 OFF2000: Unable to Install Internet Explorer 5 in Office Maintenance Mode Setup Q229381 KB229381 January 24, 2007
229375 OFF2000: "Web Browsing Component Only" Installs Internet Explorer 5 Q229375 KB229375 January 24, 2007
229006 XL: Colors in HTML File Don't Appear as Expected When Opening Page in Excel Q229006 KB229006 January 24, 2007
228690 OFF2000: Extra Programs Listed in Removing Previous Versions Dialog Box Q228690 KB228690 January 24, 2007
228677 You receive a "Could not find a package to install on the installation media" error message when you run Office 2000 Setup from an administrative installation point Q228677 KB228677 January 24, 2007
228668 You receive an "Internal Error 2343" error message after you remove Lotus Notes and then install Office 2000 Q228668 KB228668 January 24, 2007
228666 OFF2000: Error Message: "Another Version of This Product Is Already Installed" After Restart Q228666 KB228666 January 24, 2007
228658 You receive an "Error 1303. The installer has insufficient privileges to access this directory" error message when you run Office 2000 Setup Q228658 KB228658 January 24, 2007
228655 You receive an "Error 1704. An installation for <Office product> is currently suspended" error message when you install Office 2000 Q228655 KB228655 January 24, 2007
228639 You receive an "Error applying transforms" error message when you run Office 2000 Setup from a hyperlink Q228639 KB228639 January 24, 2007
228631 OFF2000: Motionless Office Assistant Is Always Installed to \Program Files\Microsoft Office\Office Folder Q228631 KB228631 January 24, 2007
228616 OFF2000: Exit Setup Dialog Box Appears Unexpectedly When You Press the ENTER Key Q228616 KB228616 January 24, 2007
228594 XL2000: "Couldn't Open the OLAP Cube Wizard" Error Starting OLAP Cube Wizard Q228594 KB228594 January 24, 2007
227813 OFF2000: Setup Switch /q or /qb Required on Windows NT or Windows 2000 Q227813 KB227813 January 24, 2007
226530 OFF2000: UserName and CompanyName Fields Not Set to Blanks Q226530 KB226530 January 24, 2007
226517 OFF2000: "Keep these programs" Check Box Unavailable Q226517 KB226517 January 24, 2007
225029 How To Determine Which Version of Excel Wrote a Workbook Q225029 KB225029 January 24, 2007
224925 INFO: Type Libraries for Office May Change with New Release Q224925 KB224925 January 24, 2007
224533 Uninstalling Microsoft Access or Microsoft Office removes the System.mdw file and the sample databases Q224533 KB224533 January 24, 2007
224435 OFF2000: Errors Running Office from CD-ROM Q224435 KB224435 January 24, 2007
224434 OFF2000: Beta 2 Not Detected During Setup Q224434 KB224434 January 24, 2007
223789 How to minimize metadata in Microsoft Excel workbooks Q223789 KB223789 January 24, 2007
223396 How to minimize metadata in Office documents Q223396 KB223396 January 24, 2007
221492 Publishing cells with spilled text creates merged cells in Excel Q221492 KB221492 January 24, 2007
221455 Windows Installer starts to install a program when you click the Office 2000 program shortcut Q221455 KB221455 January 24, 2007
221438 Files with names that begins with "fff" appear in your Windows folder after you install Office 2000 Q221438 KB221438 January 24, 2007
221437 OFF2000: Task Scheduler Is Turned On After Installing Office Q221437 KB221437 January 24, 2007
221374 OFF2000: Internal Error 2893 When Specifying Long Company Name Q221374 KB221374 January 24, 2007
221354 You receive a "There was a problem starting the Office Assistant" error message when you run an Office 2000 program Q221354 KB221354 January 24, 2007
221077 Gridlines are not displayed in Web browser Q221077 KB221077 January 24, 2007
221070 Decimal points in Accounting format are not aligned in browser in Excel Q221070 KB221070 January 24, 2007
220885 OFF2000: Setup Overwrites Office 95 or Office 97 Start Menu Items Q220885 KB220885 January 24, 2007
220791 You receive a "Command line option syntax error" error message when you install Office 2000 Q220791 KB220791 January 24, 2007
220780 You receive an "Internal Error 2755" or an "Exception code: C0000005 ACCESS_VIOLATION" error message when you install Office 2000 or view the Setup log file for an earlier installation of Office Q220780 KB220780 January 24, 2007
219423 How to remove the Office 2000 CD1 Q219423 KB219423 January 24, 2007
218883 OFF2000: Pros and Cons of Run From Server Installations Q218883 KB218883 January 24, 2007
217714 Setup appears to stop responding and you receive an "Internal error 2336" or an "Internal error 2755" error message when you install Office 2000 Q217714 KB217714 January 24, 2007
217706 You receive a "The feature you are trying to use is on a CD-ROM or other removable disk that is not available" error message when you try to remove Office 2000 Q217706 KB217706 January 24, 2007
217697 OFF2000: Installation Error Prompting Previous User to Reinstall Office Q217697 KB217697 January 24, 2007
217683 OFF2000: Maintenance Mode Requires 1280KB of Disk Space in Addition to the Features That You Choose to Add Q217683 KB217683 January 24, 2007
217674 OFF2000: Setup of Second Office 2000 CD, Does Not Remember Previous CD's Installation Path Q217674 KB217674 January 24, 2007
217673 OFF2000: Setup Error "Installation was not completed successfully" in Quiet Mode Q217673 KB217673 January 24, 2007
217666 You receive an "Error 1327. Invalid Drive: C:\" error message when you install Office 2000 Q217666 KB217666 January 24, 2007
217662 OFF2000: Error 1925 When You Run Setup with the /J Switch Q217662 KB217662 January 24, 2007
217648 OFF2000: "Warning 1909. Could not create shortcut" During Setup Q217648 KB217648 January 24, 2007
217605 You receive a "The application failed to initialize because the window station is shutting down" error message when you are prompted to restart Windows after you run Office 2000 programs for the first time Q217605 KB217605 January 24, 2007
217585 OFF2000: Not Enough Disk Space Message When You Install Office Q217585 KB217585 January 24, 2007
217560 Setup does not run or you receive an "Error opening installation log file" error message when you run Office 2000 Setup Q217560 KB217560 January 24, 2007
217548 OFF2000: Out of Disk Space Error When Reinstalling Office Q217548 KB217548 January 24, 2007
217546 OFF2000: Internet Explorer Compatibility Mode Not Available in Office Setup Q217546 KB217546 January 24, 2007
217543 BUG: Binder does not appear in the Office 2000 Tools program group Q217543 KB217543 January 24, 2007
217530 OFF2000: CD Key Overwritten After Pressing Backspace to Correct a Mistake Q217530 KB217530 January 24, 2007
217493 OFF2000: Internet Explorer 5 Setup Fails Without Warning Q217493 KB217493 January 24, 2007
217469 OFF2000: "Please Insert the Disk" Prompt When CD Is Inserted During Installation Q217469 KB217469 January 24, 2007
217435 OFF2000: Microsoft Office Manager View Settings Do Not Migrate to Office Shortcut Bar Q217435 KB217435 January 24, 2007
217412 OFF2000: Starting a Program Prompts for User Name on Windows NT Q217412 KB217412 January 24, 2007
215904 Changing a PivotChart removes series formatting in Excel Q215904 KB215904 January 24, 2007
215854 Data label legend keys may appear in unexpected positions in Excel Q215854 KB215854 January 24, 2007
215783 XL: "Excel Could Not Save All the Data and Formatting" Error Message Q215783 KB215783 January 24, 2007
215573 You receive an error message when you add a chart to a workbook in Excel Q215573 KB215573 January 24, 2007
214797 How To Automate Excel Using Perl for Win32 Q214797 KB214797 January 24, 2007
214462 PRB: Error "Bound to Unknown Type" Inserting ATL Control in VBA UserForm Q214462 KB214462 January 24, 2007
214282 Sorting alphanumeric text as numeric values Q214282 KB214282 January 24, 2007
214278 Row Height Changes When You Print to a Different Printer Q214278 KB214278 January 24, 2007
214275 XL: Using 16-Bit and 32-Bit ODBC Drivers Q214275 KB214275 January 24, 2007
214264 XL: How to Perform a Case-Sensitive Lookup Q214264 KB214264 January 24, 2007
214263 XL: Example on Use of Solver Q214263 KB214263 January 24, 2007
214259 How to use grouping for fields in a PivotTable in Excel Q214259 KB214259 January 24, 2007
214250 Excel cannot open MultiPlan files Q214250 KB214250 January 24, 2007
214249 How to use the Conditional Sum Wizard in Microsoft Excel Q214249 KB214249 January 24, 2007
214150 XL: Adjusting the Period of Financial Functions Q214150 KB214150 January 24, 2007
214133 XL: Formula for Distance/Velocity Returned in Hours, Minutes, and Seconds Q214133 KB214133 January 24, 2007
214114 Unexpected result pasting non-contiguous range from Excel into Word Q214114 KB214114 January 24, 2007
214093 XL: How to Display the Current Date and Time with Text Q214093 KB214093 January 24, 2007
214091 XL: Finding the Balance of a Loan for a Given Period Q214091 KB214091 January 24, 2007
214084 XL: How to Display the File Name of a Worksheet Without Using a Macro Q214084 KB214084 January 24, 2007
214070 Description of filtering and extracting a record that contains a text string in Excel Q214070 KB214070 January 24, 2007
214069 XL: How to Return the First or Last Match in an Array Q214069 KB214069 January 24, 2007
214058 Days of the week before March 1, 1900 are incorrect in Excel Q214058 KB214058 January 24, 2007
214048 You receive a "This file is not in a recognizable format" error message when you try to open a file in Works 3.0 or 4.0 format in Excel 2000 or Excel 2002 Q214048 KB214048 January 24, 2007
214033 Pie Chart Shows Incorrect Percentage Value in Excel Q214033 KB214033 January 24, 2007
213923 How to use AutoFilter to filter records based on cell formatting in Excel Q213923 KB213923 January 24, 2007
213915 How to create a Gantt chart using hours as the scale Q213915 KB213915 January 24, 2007
213901 XL: General Number Format Applied to Improper Time Entry Q213901 KB213901 January 24, 2007
213886 The AutoFilter status bar displays the "Filter Mode" message in Excel Q213886 KB213886 January 24, 2007
213841 Passed strings longer than 255 characters are truncated in Excel Q213841 KB213841 January 24, 2007
213837 How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002 Q213837 KB213837 January 24, 2007
213823 Macro that changes cell dimensions on multiple sheets does not run as expected Q213823 KB213823 January 24, 2007
213798 Sample Visual Basic macros for working with arrays in Excel Q213798 KB213798 January 24, 2007
213773 How to create data validation circles for printing in Excel Q213773 KB213773 January 24, 2007
213772 How to use system, user, and file data source names (DSN) in Excel 2000 or Excel 2002 Q213772 KB213772 January 24, 2007
213754 How to customize a custom toolbar button Q213754 KB213754 January 24, 2007
213740 How to record a macro using relative cell references in Excel Q213740 KB213740 January 24, 2007
213719 Description of the Value2 property for the Range object in Excel Q213719 KB213719 January 24, 2007
213689 Compile error occurs running a recorded macro that uses the Solver add-in Q213689 KB213689 January 24, 2007
213650 Error opening file that refers to shortcut Q213650 KB213650 January 24, 2007
213638 How to create a macro that counts comments Q213638 KB213638 January 24, 2007
213598 You cannot use the PrintOut method when the custom dialog box is visible Q213598 KB213598 January 24, 2007
213507 XL: How to Count Cells That Contain Formulas, Text, or Numbers Q213507 KB213507 January 24, 2007
213495 How to use a formula in Excel to calculate the average of a data sample without the highest and lowest values Q213495 KB213495 January 24, 2007
213476 XL: Unexpected Results with Mixed Text and Numbers in Lookup Table Q213476 KB213476 January 24, 2007
213447 XL: Visual Basic Module to Create a Gantt Chart Q213447 KB213447 January 24, 2007
213438 How to programmatically select every nth row in a range in Excel Q213438 KB213438 January 24, 2007
213413 Visual Basic macro to show active cell's range names in Excel Q213413 KB213413 January 24, 2007
213343 XL: How to Put Folder Contents into a Worksheet Q213343 KB213343 January 24, 2007
213269 Error handler ignored when Break on All Errors is selected Q213269 KB213269 January 24, 2007
213243 Odd refresh behavior after you specify a conditional format in Excel Q213243 KB213243 January 24, 2007
213189 Stop Recording Toolbar is not displayed when you record a macro Q213189 KB213189 January 24, 2007
212761 OFF2000: Application Information Missing in System Information Utility Q212761 KB212761 January 24, 2007
212446 OFF2000: How to Move a Submenu Anywhere on the Screen Q212446 KB212446 January 24, 2007
212366 Rotated text in an Excel worksheet is displayed horizontally when you view the text in a browser Q212366 KB212366 January 24, 2007
212250 Cannot add a data table to some charts in Excel Q212250 KB212250 January 24, 2007
212144 Hyphens and apostrophes are sorted after alphabetic letters in Excel Q212144 KB212144 January 24, 2007
212126 XL: Cell Appears Blank with Angled Text and Small Row Height Q212126 KB212126 January 24, 2007
212074 A Visual Basic procedure that opens a workbook may halt in Excel Q212074 KB212074 January 24, 2007
212064 XL: F4 Key Does Not Change Cell Formula Reference As Expected Q212064 KB212064 January 24, 2007
212035 XL2000: Constrained Line or Arrow Is Pasted Incorrectly Q212035 KB212035 January 24, 2007
211951 Overview of the built-in chart types in Excel Q211951 KB211951 January 24, 2007
211933 Chart display options change according to page setup Q211933 KB211933 January 24, 2007
211835 How to control the placement of objects Q211835 KB211835 January 24, 2007
214042 You receive an error message when you access files from a floppy disk in Excel Q214042 KB214042 January 23, 2007
211816 Comments may not be printed as expected Q211816 KB211816 January 23, 2007
211580 Only 1,024 characters are displayed in a cell in Excel Q211580 KB211580 January 23, 2007
211557 Additional columns or rows that are not selected may be added to the print titles when you create print titles on a worksheet in Excel Q211557 KB211557 January 23, 2007
211515 Using server page fields in PivotTables in Excel Q211515 KB211515 January 23, 2007
211391 OFF: Printer Name Not Listed in Print Dialog Box Q211391 KB211391 January 23, 2007
210391 OFF2000: Setup May Remove Older Components Q210391 KB210391 January 23, 2007
210320 Web page saved in Excel displays differently in Web browser Q210320 KB210320 January 23, 2007
210055 OFF2000: Copy To Commands Missing in Bookshelf After Upgrade Q210055 KB210055 January 23, 2007
209121 Excel HTML file always displayed at 100 percent zoom Q209121 KB209121 January 23, 2007
207475 DOC: Excel BIFF8 CONTINUE Record Information Is Incomplete Q207475 KB207475 January 23, 2007
205548 How to use A functions in Excel Q205548 KB205548 January 23, 2007
203078 Office Shortcut Bar (OSB) setup, startup, and exit behavior is different from earlier versions of Office Q203078 KB203078 January 23, 2007
202991 One Office Assistant is installed by default when you install Office 2000 Q202991 KB202991 January 23, 2007
201487 Patterns do not display in a Web browser in Excel Q201487 KB201487 January 23, 2007
200378 How to install Windows 98 to a new folder to troubleshoot problems in Office 2000 Q200378 KB200378 January 23, 2007
200375 OFF2000: How to Install Windows 95 to a New Folder to Troubleshoot Office Q200375 KB200375 January 23, 2007
199901 OFF2000: Removing Templates Removes Modified Database Files Q199901 KB199901 January 23, 2007
199879 OFF2000: Remove All Doesn't Remove Temporary Shortcut Bar Files Q199879 KB199879 January 23, 2007
199368 OFF2000: Clicking "Remove Office" During Setup Removes Inbox Q199368 KB199368 January 23, 2007
199345 OFF2000: Templates Missing from Binder Add Section Q199345 KB199345 January 23, 2007
199340 You receive a "There is not enough free memory to run this program" error message when you start an Office 2000 program Q199340 KB199340 January 23, 2007
199201 XL: Cannot Move or Resize Chart Objects in a PivotChart Q199201 KB199201 January 23, 2007
194611 How To Create and Call an Excel Macro Programmatically from VB Q194611 KB194611 January 23, 2007
190630 Kernel32.dll and other error messages when you install Office 2000 products with Direct Memory Access (DMA) enabled on Windows 95 or Windows 98 Q190630 KB190630 January 23, 2007
189897 Data truncated to 255 characters with Excel ODBC driver Q189897 KB189897 January 23, 2007
186122 How to use MFC to automate Excel 2000 and Excel 2002 and obtain an array from a range in Excel 2000 and Excel 2002 Q186122 KB186122 January 23, 2007
186120 How To Use MFC to Automate Excel and Fill a Range with an Array Q186120 KB186120 January 23, 2007
185978 FIX: Double GET requests and cookies are lost with Word 2000 or Excel 2000 Q185978 KB185978 January 23, 2007
182812 Description of the Value2 property for the Range object Q182812 KB182812 January 22, 2007
182197 The General number format rounds off real numbers in Excel Q182197 KB182197 January 22, 2007
181889 BUG: VB Hangs While Automating Excel Using OLE Control Q181889 KB181889 January 22, 2007
181201 HLOOKUP, VLOOKUP, LOOKUP return incorrect values in Excel Q181201 KB181201 January 22, 2007
179824 XL: Features and Formatting Lost Saving to Excel 5.0/95 Q179824 KB179824 January 22, 2007
179706 How to use MFC to automate Excel and create and format a new workbook Q179706 KB179706 January 22, 2007
178605 How To Determine the Version of a Microsoft Excel Workbook Q178605 KB178605 January 22, 2007
177842 OFF97: Invalid Page Fault with More Than 411 Controls in UserForm Q177842 KB177842 January 22, 2007
176838 You receive an error message when you use the Paste Special command in Excel Q176838 KB176838 January 22, 2007
898511 When you programmatically save a workbook in Excel, a menu command does not run in the BeforeSave event Q898511 KB898511 January 20, 2007
171280 PRB: Error Message "Cannot insert object" in Excel Q171280 KB171280 January 20, 2007
170784 Supported installation methods for deploying Microsoft Office Q170784 KB170784 January 20, 2007
168437 XL: Unable to Select Defined Names by Using Function Wizard Q168437 KB168437 January 19, 2007
164383 No Tables Appear in Add Tables Dialog Box Q164383 KB164383 January 19, 2007
164317 How to sum a range of cells based on a number format in Excel Q164317 KB164317 January 19, 2007
162814 Sample macros to return ID for a CommandBar control Q162814 KB162814 January 19, 2007
162028 Formatting is not retained in PivotTable in Excel Q162028 KB162028 January 19, 2007
151364 Glossary of charting terminology in Excel Q151364 KB151364 January 19, 2007
149235 How to help prevent file corruption in Excel Q149235 KB149235 January 19, 2007
141762 XL: How to Use Looping Structures in Visual Basic for Applications Q141762 KB141762 January 19, 2007
141759 SAMPLE: XLCLIENT: Automation Client for Excel Q141759 KB141759 January 19, 2007
141692 Visual Basic Example to Retrieve Value from Last Cell Q141692 KB141692 January 19, 2007
138010 OFF: Office Only Runs on Intel-Based Computers Q138010 KB138010 January 19, 2007
134913 XL: GetCustomListNum Returns Unexpected List Number Q134913 KB134913 January 19, 2007
131384 XL: EVALUATE() Function with INDIRECT() Returns #REF! Error Q131384 KB131384 January 19, 2007
123198 XL: How to Compute the Average Growth Rate of an Investment Q123198 KB123198 January 19, 2007
123183 How to export data to a text file with comma and quote delimiter in Excel Q123183 KB123183 January 19, 2007
121824 Toolbar Button Capable of Alternate Action Q121824 KB121824 January 19, 2007
119826 Macro to Remove Hidden Names in Active Workbook Q119826 KB119826 January 19, 2007
119083 XL: MOD() Function Returns #NUM! Error Value Q119083 KB119083 January 19, 2007
117128 XL: Hidden Cells in a Worksheet May Become Unhidden Q117128 KB117128 January 19, 2007
927198 MS07-002: Vulnerabilities in Microsoft Excel could allow remote code execution Q927198 KB927198 January 18, 2007
110854 XL: How to Compute the Periodic Annual Interest Rate in Microsoft Excel Q110854 KB110854 January 18, 2007
105111 XL: Sorting Feature Ignores Hidden Rows Q105111 KB105111 January 18, 2007
100825 #VALUE error when you add text and values in Excel Q100825 KB100825 January 18, 2007
100782 XL: Method Used by Goal Seek to Find a Solution Q100782 KB100782 January 18, 2007
100149 ACC: How to Use the Quit Macro Action or Quit Method Q100149 KB100149 January 18, 2007
830349 Description of the Excel 2000 Security Patch: November 11, 2003 Q830349 KB830349 January 17, 2007
310744 How To Dismiss a Dialog Box Displayed by an Office Application by Using Visual C++ .NET and MFC Q310744 KB310744 January 17, 2007
307292 How To: Dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET Q307292 KB307292 January 17, 2007
259971 How To Dismiss a Dialog Box Displayed by an Office Application with Visual Basic Q259971 KB259971 January 17, 2007
823573 How to determine the number of unique items in a list in versions 97, 2000, and 2002 of Excel Q823573 KB823573 January 16, 2007
930477 A color hairline border in an Excel worksheet may be printed as a black solid border that has a heavier line weight Q930477 KB930477 January 12, 2007
895618 An Office update does not appear to be installed after you install the update Q895618 KB895618 January 12, 2007
268016 Internet Explorer cannot open an Excel Add-In (*.xla) file Q268016 KB268016 January 10, 2007
268134 XL2000: Quattro Pro 7.0 (.wb3) Converter Available Q268134 KB268134 January 9, 2007
247796 XL2000: Programmatically Exporting Text File Truncates Dates Q247796 KB247796 January 9, 2007
217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects Q217221 KB217221 January 9, 2007
154876 You receive an error message when you use right bracket in text file name in Excel 2003 and earlier versions Q154876 KB154876 January 6, 2007
279408 PRB: Office Application That Hosts a Custom ActiveX Control Fails on the Save or Save As Method Q279408 KB279408 January 5, 2007
930204 The specifications for the smallest and largest allowed positive and negative numbers are wrong in the Help files for Excel Q930204 KB930204 January 4, 2007
230137 Some files do not print when you use Windows Explorer to print files from Excel 2007, Excel 2002, or Excel 2000 Q230137 KB230137 January 4, 2007
199337 OFF2000: Memory Problems When Hyperlinking Between Programs Q199337 KB199337 January 4, 2007

Excel 2000 articles, fixes and updates - January 2007