MULTI-PAGE SCHEDULES

Revit doesn't do multi-page sheets, therefore if a schedule doesn't fit on one sheet it needs to be manually split between multiple individual sheets.

There are 2 methods:

Filter schedules to control what appears on a sheet

Export to Excel and print from Excel.

FILTERED SCHEDULES

CREATE MULTIPLE SCHEDULES

First create the schedule how want it to appear.

Then duplicate it, creating a separate schedule for each sheet.

CREATE THE FILTER

Make a decision about which filter is best to use for identifying which sheet a row appears on.

For example if you are group a material schedule by specification section use that:

For a door schedule use the door mark:

PLACE ON SHEETS

Place the schedules created on to sheets.

Adjust the filter as required to fit the schedule within the sheet.

PRINT FROM EXCEL

This only works as an efficient workflow if NO EDITING IS DONE IN EXCEL.

If data from Revit is editing it is no different from manually doing schedules.

Note that images in schedules can not be exported to Excel.

The process to set up it up:

1. In Revit create a schedule with the columns, ordering and filters you want.

2. Export that schedule as a tab delimited text file (default Revit export).

3. Open Excel and import the exported .txt file.

4. Format the way you want it to look.

5. DO NOT ADD ANY ADDITIONAL DATA OR EDIT ANY DATA.

6. Print it.

When you need to print again:

1. Export the schedule from Revit.

2. Open the Excel file (the Revit import will update automatically).

3. DO NOT ADD ANY ADDITIONAL DATA OR EDIT ANY DATA.

4. Print.

Full instructions can found at:

GUIDELINES > SCHEDULES > LINK SCHEDULE EXPORT TO EXCEL

If you do want to add data in Excel or combine multiple schedules in to one it is a bit more complicated.

For an example of how to do this refer to:

GUIDELINES > SCHEDULES > EXCEL AREA SCHEDULE