This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Project 98, when you use the Analyze_Timescaled_Data macro toexport data to Microsoft Excel, you may see any of the following symptomswhen you view the data in Microsoft Excel:
Symptom 1: Cost or Work Values Are Greater Than Expected
Cost or work values for a task, resource or assignment may be greater thanexpected.
For example, a resource with 8h work and $1/hr cost will have the followingvalues in Microsoft Excel:
Work 800.000,00h Cost $800.000,00
Symptom 2: Costs Are Displayed in Scientific Notation
Costs are displayed in scientific notation (for example, 1E+07.00000) andare not included in totals.
Symptom 3: Costs Are Rounded to an Incorrect Value
Most commonly, only decimal values of costs are rounded to an incorrectvalue.
Symptom 4: Start and Finish times are not exported
Only start and finish dates are exported; start and finish times are notexported.
These behaviors may occur when you run the Analyze_Timescaled_Data macrothat ships with Microsoft Project 98 and any of the following conditionsare true.
Condition for Symptom 1: Cost or Work Values Are Greater Than Expected
Cost or work values for a task, resource or assignment may be greater thanexpected when the Digit Group Symbol is a period (.) and the Decimal Symbolis a comma (,) under Regional Settings in Control Panel.
Condition for Symptom 2: Costs Are Displayed in Scientific Notation
Cost values greater than or equal to 9,999,999.50 in any of the followingfields may be displayed in scientific notation (for example, 1E+07.00000)and are not included in Totals:
Condition for Symptom 3: Costs Are Rounded to an Incorrect Value
Values greater than or equal to $999,999.00 in the following fields may berounded to an incorrect value:
Condition for symptom 4: Start and Finish Times Are Not Exported
Start and finish values are rounded to the nearest whole day.
To correct symptoms 1-3, follow these steps:
Obtain and install Microsoft Project 98 for Windows, Service Release 1 (SR-1). See the "Status" section later in this article for information about obtaining and installing SR-1.
Start Microsoft Project 98 SR-1.
On the File menu, click Open.
Find and open the Backup.mpt file.
NOTE: This file is found in the same directory where Winproj.exe is located. The default location is:
C:\Program Files\Microsoft Office\Office.
In the Organizer dialog box, click the Modules tab.
Under the BACKUP.MPT column, click Analyze_Timescaled_Data.
Click Copy. Click Yes when prompted to replace the existing Module Analyze_Timescaled_Data
NOTE: The arrows should be pointing from the BACKUP.MPT column to the GLOBAL.MPT column.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was corrected in Microsoft Project 98 for Windows, Service Release 1 (SR-1).
For additional information about obtaining and installing SR-1, please seethe following article in the Microsoft Knowledge Base:
185102 PRJ98: How to Obtain and Install MS Project 98 SR-1
NOTE: See the "Workaround" section of this article for additional steps after obtaining SR-1.