Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
other
informationbridge
office.intranets
office.misc
office.setup
office.xml
officeupdate
onenote
photodraw.discussion
powerpoint
producer
proj.standard&server
project
project.developer
project.pro_and_serve
project.server
project.vba
project2000
publisher
publisher.prepress
publisher.programming
publisher.webdesign
visio
visio.createshapes
visio.database.modeling
visio.dev.diagrams
visio.dev.shapesheet
visio.dev.vba
visio.dev.vc
visio.developer
visio.general
visio.installation
visio.printing
visio.software.modeling
visio.troubleshoot
  
 
date: Tue, 20 May 2008 06:46:00 -0700,    group: microsoft.public.visio        back       


how do you get visio gantt to read excel properly?   
i have a task list specifically filled in using the GANTT template output 
format. the column headers are exactly what it is looking for, yet everytime 
i try to import the excel file, it tells me i don't have the proper headers.

short of throwing my laptop out the window, i am at a loss.
date: Tue, 20 May 2008 06:46:00 -0700   author:   Kerry

RE: how do you get visio gantt to read excel properly?   
Hi Kerry --
Hmmm.  Laptops can be expensive.  As a sanity check, you might try this.  
Create a new Gantt chart in Visio from scratch, i.e., not importing an data.  
Number of rows isn't important.  Setup the columns that you desire.  Then, 
export this chart.  Let this become a "template" for your Excel data.  Copy 
and paste your data, save as a new file.  Close it.  Go back to Visio, and 
import this new file.  Should be OK.  You can compare the template with your 
old file for header discrepancies.

Hope this helps.  (If it does, you owe me a new laptop?  Just kidding.)
Wapperdude



"Kerry" wrote:

> i have a task list specifically filled in using the GANTT template output 
> format. the column headers are exactly what it is looking for, yet everytime 
> i try to import the excel file, it tells me i don't have the proper headers.
> 
> short of throwing my laptop out the window, i am at a loss.
date: Tue, 20 May 2008 10:38:00 -0700   author:   WapperDude

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us