Project 2003 Errors on Excel Import

[Lori_MN_PM]

I am trying to import an Excel project plan into MS-Project. Following the
instructions, I've completed:

1. FILE/OPEN/<Chose Directory/Filename/File Format>
2. This triggers the Import Wizard. I answer that this is a new project
map I am creating, that I need the "Task, Assignmnet, & Resource" data, then
go through the next screen & complete he mapping. The previous shows my data
perfectly.
3. The problem is, at the top of this screen, the Project Import Wizard
picks up the name of my worksheet in a drop down box (this is the good part),
but when I push the FINISH button on the bottom of this screen, I get the
message, "The source worksheet name is required. One or more worksheet name
fields are blank. A worksheet name is required to import data."

Thus I am stuck. Although the wizard is successfully displaying in its drop
down box the name of my worksheet in my Excel file, it claims to not have
the name and won't complete the import mapping. HELP!!!

Lori T.

 

[Lori_MN_PM]

Please allow me to correct my Typo's for better reading:

I am trying to import an Excel project plan into MS-Project 2003. Following
the import instructions, I have:

1. FILE/OPEN/<Chose Directory/Filename/File Format>
2. This triggers the Import Wizard. I answered: that this is a new
project map;
that I need the "Task, Assignment, & Resource" data; then go through
the next
screen & complete the mapping. The preview shows my data mapped
perfectly.
3. The problem is although at the top of this Wizard import screen my
worksheet
name is automatically displayed in a drop down box (which is the good
part),
when I push the FINISH button on the bottom of this screen, I get the
error message, "The source worksheet name is required. One or more
worksheet name fields are blank. A worksheet name is required to
import
data."

Thus I am stuck. Although the project import wizard is successfully
displaying the excel worksheet name in its drop down box, the Wizard claims
to not have the excel worksheet name and won't complete the import mapping.
HELP!!!

Lori_T

 

[rsturk]

Lori:

Did you or anyone else find a resolution for this? If so what is it