Export of Excel 97 dates into MS Project 98 seems not workin
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Export of Excel 97 dates into MS Project 98 seems not workin

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Brussels
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi again,

    I try to use softs for what they are at best: Excel to manipulate dates and tasks names, MS Project to display the GANTT chart (although I used to play with conditional formatting in Excel too.

    However I am at a loss to try to dump Excel dates into MS Project (using in MS Project the Open-Map from Excel file): whatever I do, MS Project considers the dates of Excel as text and not dates (I tried and checked carefully the cell format): therefore the import of data from Excel to MS Project does not work. I even tried to export dates from MS Project to Excel, and the Map keeps on saying the dates of MS Project are text field!!!

    How can I overcome this? Is there any patch to use with Excel or MS Project?

    Thanks for any reply

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Clearwater, FL
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've used project some: have you tried copying the whole column of dates from excel and PASTING them into Project? That might work...

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Brussels
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi,

    Yes, it will work indeed, I used it. But I want to automate this (weekly updates).

    Thanks anyway

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com