How do I avoid "operation failed" toimport an excel file into proj

[Connie]

 

[JulieS]

Connie,

We really need some more information. Please see:

http://project.mvps.org/posting.htm


Julie
Project MVP

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

 

[Connie]

I am using Project 2003 and Excel 2003. I have created tasks in an Excel
spreadsheet comprising of the following fields:

Description
Start Date
Finish Date
Percent Complete
Resource Name
Notes

I am using the following commands:

File/Open/(Select my excel file)...then the wizard kicks in for mapping. I
map all the fields, Click on finish and get the following message "Operation
Failed"

 

[Jim Spiller]

If you are using SP3, try going to Tools-Options-Security and selecting the
"Allow Legacy and Non-default file formats..." option.

 

[Connie]

I just checked and I only have SP2 installed. Is this problem an issue that
was corrected with SP3?

 

[JulieS]

Hi Connie,

Thanks for the additional information. Yes, there was a security
update in April which caused the problem with the "legacy" formats.
SP-3 (released before the update) with the option to allow legacy
fixes the issue.

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

 

[Jim Spiller]

SP2 adds the feature to Project 2003 that prevents you from working with
alternate file formats with no way to turn this off within the program.
Installing SP3 adds the option mentioned to turn this off... I would suggest
downloading and installing SP3.

 

[JulieS]

Actually it wasn't SP-2, it was the security update in April of 2008
which caused the problem. Actually I believe you can edit the
registry to fix the issue without installing SP-3, but I recommend
installing SP-3.

See http://support.microsoft.com/kb/948962

Julie

 

[Chuck D]

Hi All,

I just installed SP3 to try to get around this error. All MS-Applications
are showing at the SP3 level with the exception of MS-Project. It still shows
at SP2. And I still get the operation failed error. Did I miss something in
the application of SP3 or is there something else that needs to be installed
for MS-Project?

Thanks, Chuck

 

[JulieS]

Hi Chuck
Service Pack 3 for MS Project is a separate install from the rest
of Office.

See:
http://www.microsoft.com/downloads/...7B-2C58-4A70-B808-4D7A1B26535E&displaylang=en

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

 

[Chuck D]

Thanks! This did the trick as it now works!

Hi Chuck
Service Pack 3 for MS Project is a separate install from the rest
of Office.

See:
http://www.microsoft.com/downloads/...7B-2C58-4A70-B808-4D7A1B26535E&displaylang=en

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

 

[JulieS]

Great. Glad to know all is better and thanks for the feedback.
Julie