Importing from Excel errors after installing Office SP3

[Bendinblues]

I am now getting an error when I try to import some Excel files after
installing SP3. The error reads......An unexpected error occurred during
comman execution. try the following: Verify that all argument names and
values are correct and are of the correct tyoe. You may be out of memory.
Neither condition is true.

 

[Mike Glen]

Hi Bendinblues ,

Welcome to this Microsoft Project newsgroup

Please see FAQ Item: 18. Memory Problems. The princilpe applies to all
versions of Project.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on


Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[Bendinblues]

Mike,

Thanks for the prompt reply. however, problem still exists.

I have tried importing these Excel sppreadsheets on 2 separate computers and
get the same replies. I import 12 excel spreadsheets weekly using same map. 7
of them imported with no problem; the other 5 came up with this error
message. A relatively close inspection of the data in project appears to show
that the data imported properly. but I am a bit skeptical due to the presence
of this error message.

Any other suggestions?

 

[Bendinblues]

Mike,

I saved the problematic Excel files as version 95 and they imported without
an error. the minute I resaved them as 2003, the error reappeared!

 

[JulieS]

Hello Bendinblues,

Try changing your legacy file settings. On the Tools > Options,
Security tab -- set the legacy setting to "allow".

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

 

[Bendinblues]

Julie,

Thanks for your reply.

Project is already setup to allow loading of legacy files or files with
non-default formats.

This error is really baffling me. i even tried deleting some of the tabs in
the workbooks before importing thinking that reducing the size of the
workbook might complete the import without the error.

I could use more suggestions if you can muster them!

Bendin

 

[JulieS]

Hi Bendin,

If you are able to import seven files without trouble but 5 with
trouble, are there differences between the Excel files? Sometime
ago, I remember a problem with spaces or punctuation in the sheet
tab names causing some trouble. Is it possible that the 5 errant
files have a difference in sheet tabs?

Julie