Home › Forums › Discussion Forum › Excel import into MS Project 2016 with regular intervals
Hi All,
Please can you assist.
My company is working on a project where each department uses excel to provide feedback to my team.
Is there a way in which they can continue to update their excel docs, but allow my team to use MS Project to update the project plans.
I have tried the importing function in MS Project, but the mapping does not seem to be very accurate.
The question i have is that, do we need any additional tools to map to correctly to import? Does MS Project server resolve this?
What are my options?
Thanking in advance
I think that’s an excellent question, unfortunately (from my experience), u need a custom macro designed for your setup. Ive never seen the 2016 (or 2019) standalone version successfully import and export sheets with precision, unless u hire someone to make it so. But I’ve been retired a few years now… perhaps there is a younger solution.