Data Import & Export

How to Automatically Link Microsoft Project Dates to Excel

Huda Qurayshi Oct 10, 2026 868 views

Question details

Establish a live link between Microsoft Project and Excel so that start dates, finish dates, and durations update automatically in Excel without manual exporting or coding.

How to Automatically Link Microsoft Project Dates to Excel

Product: Microsoft Project, Microsoft Excel
Device & OS: not provided
Scenario: Users want to keep project timelines synchronized between Microsoft Project and an Excel spreadsheet automatically.
Observed behavior: Microsoft Project lacks a native live-sync feature for Excel; standard exports result in static data that does not update automatically.

Before you start

Ensure you have both Microsoft Project and Microsoft Excel installed, and verify that your macro security settings allow the execution of VBA scripts if you choose the macro-based workaround.

Solution 1Recommended

Set Up an Event-Triggered VBA Macro in Microsoft Project

Since there is no native live link, using a VBA macro that runs when the Project file closes is the most effective workaround to keep Excel updated automatically.

Microsoft Project does not offer a direct live-link feature to Excel. To achieve automatic synchronization, you must set up an event-driven macro within MS Project that pushes the updated dates and durations to your Excel file whenever you close the project.

Open the VBA Editor

Launch Microsoft Project, open your project file, and press ALT + F11 to open the Visual Basic for Applications (VBA) editor.

Create an Event Handler

In the Project Explorer pane on the left, double-click 'ThisProject' to open the code window. Select 'Project' from the left dropdown and 'BeforeClose' from the right dropdown to create the event trigger.

Write the Export Code

Insert your VBA code to open the target Excel workbook in the background, locate the appropriate cells, and copy the start dates, finish dates, and durations from your MS Project fields.

Save as Macro-Enabled

Save your Project file in a macro-enabled format. Close the file to trigger the macro and verify that your Excel spreadsheet receives the updated data.

Set Up an Event-Triggered VBA Macro in Microsoft Project

Requires VBA Knowledge: This method requires writing or adapting a custom VBA script. If you are not familiar with VBA coding, you may need to consult macro tutorials or use third-party automation software.

Solution 2

Create an Automation Workflow with Power Automate

For a no-code alternative, you can use Microsoft Power Automate to schedule regular data transfers between Project for the Web and Excel Online.

Free Microsoft Office alternative

Manage Your Project Timelines Easily with WPS Office

Connecting Microsoft Project to Excel often requires complex macros or external automation. WPS Spreadsheet offers a lightweight, highly compatible environment where you can build powerful project trackers and Gantt charts directly, without the syncing hassle.

1. Download WPS Office: Download and install the free version of WPS Office from the official website.
2. Open a Project Template: Launch WPS Spreadsheet, navigate to the template library, and search for 'Project Management' or 'Gantt Chart'.
3. Track Dates Easily: Enter your project start dates, finish dates, and durations directly into the spreadsheet to visually track your timeline without needing external syncing tools.

100% compatible with Microsoft Excel formats (.xlsx, .xls)Supports VBA macros for advanced task automationFree, lightweight, and easy to install on any deviceBuilt-in project management and Gantt chart templates ready for immediate use

microsoft office alternative - wps office

Frequently Asked Questions

Can I link Microsoft Project to Excel natively without using VBA?

Natively, Microsoft Project does not support live, automatic syncing with Excel without using VBA macros. You must either manually export the data or use external automation tools like Microsoft Power Automate.

Why don't my exported Project dates update in Excel automatically?

When you perform a standard export from Microsoft Project to Excel, the data transferred is static. To keep the information updated dynamically, you must establish an event-triggered macro or a scheduled automation workflow.

Does WPS Spreadsheet support Excel macros for automation?

Yes, WPS Spreadsheet supports VBA macros, allowing you to run existing Microsoft Excel scripts or create new ones to automate your data transfer and project tracking tasks.

Excel & Data Problems