Forum Discussion
It should be so simple…
I just need to make 100’s of project files, just to put a start stop date in…. Looong time. I have a client that wants to a gantt of when we start and stop all sorts, from ppms, reactives to big projects… I have all the data i need in excel, just knowing where to dump it to just do this for me without making up 330 files i have 330 jobs….
If this is something that needs to be updated weekly/monthly by the customer I would look for a more robust solutions and put it in Project or Planner Premium. If this is something you will be doing periodically try the following options.
Assuming there are no dependencies among the 100's of projects in your list this can be done in Excel or directly connected to Power BI.
For Excel, go to File, New then search for a Gantt template.xls, which you should be able to easily modify to accept missing columns then just copy/paste your data,
For Power BI, connect directly to your Excel file to ingest the data then add a custom Gantt visual. Be forewarned as many of the Gantt custom visuals leave a lot to be desired.