Importing Excel Plan into MS Project Problem

L

Lori_MN_PM

I am trying to import an Excel project plan (not a template version) into
MS-Project 2003. Following the import instructions, I have done:

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 in this
dialog
box 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
How to import Start/Finish Data from Excel 1
Project import wizard failing "the source worksheet name is requir 2
import problems 0
Assignment Unique ID Different in Extract Map 0
Project 2003 Errors on Excel Import 2
Importing Excel2007 into Project2003 - Error on Import Wizard 1
Import - Corrupting Predecessors in Project 2007 3

Top