Importing Excel2007 into Project2003 - Error on Import Wizard

[rclevejones]

In the process of developing a task map for excel [2007] import to project
[2003]. When selecting 'finish' after setting up the task map the following
message is generated -"The source worksheet name is required. One or more of
the source worksheet name fields are blank. A worksheet name is required for
importing data." Could someone interpret what this message is trying to
convey?

 

[JulieS]

Hello,

Usually that message will appear in the middle of creating the
import map, not at the end.

When working through the import wizard on the task mapping page, you
need to select the worksheet name which contains the data you wish
to import. It's possible that when you initially created the import
map the name of the worksheet was different than the worksheet name
on your new file. Review the import wizard settings and ensure the
different workbooks have the same names for the worksheets.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project