Copy & pasting data into Excel from project 2000

[Carmen]

My project plan keeps crashing when I try to copy and paste data from
Microsoft project 2000 professional into Excel

 

[Andrew]

Carmen,

MSP can appear to crash when you copy a lot of data. It can egg-time for
quite a while.

Rather than copying and pasting try saving the data you want as an Excel
spreadsheet.

If you go to File, Save As and chose Microsoft Excel Workbook in the Save as
type drop down and then click Save.

You can then chose which data you want to export to the spreadsheet by using
or creating your own map and which filters, if any you want to apply.

Hope this helps.

Andrew

 

[John]

My project plan keeps crashing when I try to copy and paste data from
Microsoft project 2000 professional into Excel

Carmen,
What type of data are you trying to copy and paste? If it is static data
(i.e. not timescaled from one of the Usage views), you can use the
export map method suggested by Andrew. However, if the data is
timescaled you should try using the "analyze timescaled data in Excel"
add-in/utility found on the Analysis toolbar. A third option is to
develop a VBA macro to export and format the exact data you need. In my
opinion, if you are dealing with timescaled values and need to do the
transfer on a regular basis, a macro is the way to go.

Hope this helps.
John
Project MVP