Gantt Chart Import Invalid Column Error

Andrew Lavinsky

unread,

Jan 21, 2010, 5:18:08 PM1/21/10

to

Trying to import an Excel table into the Gantt Chart in Visio. The Finish
date works fine, but every time I try to map the Start date, I get an
"Invalid Column Format" error. Tried changing the format of the Start date
field, and it doesn't change anything.

Excel 2007
Visio 2007 SP2 and 2010 Beta, both with the same issue.

Any suggestions?

angi

unread,

Jan 29, 2010, 6:50:18 PM1/29/10

to

some people have luck with exporting a file from Visio first, then using that as a dummy file to enter data into and import back. I also found that visio chokes on blank date fields.

---
frmsrcurl: http://msgroups.net/microsoft.public.visio/Gantt-Chart-Import-Invalid-Column-Error

Mark Garcia

unread,

Aug 6, 2010, 12:18:14 PM8/6/10

to

The issue is that every row you import MUST have a valid start date. Common mistakes are to have empty cells for which a task exists, but no start date in the column for that task. Even if you export out of visio first and then in the xls file remove the start date for any task, and re-import it, you will get the same error.

angi wrote:

some people have luck with exporting a file from Visio first, then using that

29-Jan-10

some people have luck with exporting a file from Visio first, then using that as a dummy file to enter data into and import back. I also found that visio chokes on blank date fields.

---
frmsrcurl: http://msgroups.net/microsoft.public.visio/Gantt-Chart-Import-Invalid-Column-Error

Previous Posts In This Thread:

On Thursday, January 21, 2010 5:18 PM
Andrew Lavinsky wrote:

Gantt Chart Import Invalid Column Error

Trying to import an Excel table into the Gantt Chart in Visio. The Finish
date works fine, but every time I try to map the Start date, I get an
"Invalid Column Format" error. Tried changing the format of the Start date

field, and it does not change anything.

Excel 2007
Visio 2007 SP2 and 2010 Beta, both with the same issue.

Any suggestions?

On Friday, January 29, 2010 6:50 PM
angi wrote:

---
frmsrcurl: http://msgroups.net/microsoft.public.visio/Gantt-Chart-Import-Invalid-Column-Error

Submitted via EggHeadCafe - Software Developer Portal of Choice
Assemblies in Folder Debug Build Checker
http://www.eggheadcafe.com/tutorials/aspnet/d7de5fe1-6155-4e81-96e1-9806fd69d760/assemblies-in-folder-debug-build-checker.aspx