Note: If a task has no or multiple resources specified, then the "<Default>" resource is used for calculating dates and durations.
You can define the rest days and holidays for each resource. Rest days are non-working days repeated weekly. Holidays are not repeated automatically.
The "Import" command on the toolbar allows you to import resources and holidays from Excel ".xlsx" files.
To import external data, here are the steps to follow:
Prepare your source data in the proper format. For example, you can easily find a list of national and state holidays online. Fill your source data into the templates below to make sure it is in the proper format.
Click the "Import" button in the "Resources" window. If you want to import holidays only, you can also use the "Import" command on the "Holidays" window.
- Follow the instructions on the window to finish the import procedure.
Share Resource and Holiday Data
The definition of resources and holidays is not stored in the Excel file. They are stored in an Access database file that's shared across all the Gantt Chart projects on the computer. If you have several computers with Gantt Chart Make for Excel installed, you can even share the database between computers. To do this, follow the steps below.
Click "Settings" on the ribbon tab.
- Note the full path and name of the "Data File".
- Copy the data file to a folder where multiple computers have access to it. Make sure your Windows account has full access privileges to the folder. (How?)
- Now return to the "Settings" window. Click the "Browse" button, browse to, and open the Access database file.
- Save the Excel workbook file to make the setting persistent.