No go back to your AutoCAD file, select the entire table, and click the Download From Source icon. Once you make changes to the Excel spreadsheet, save the file. Here’s what you need to do to make sure those changes are reflected in AutoCAD and Revit as well as Excel.
Something to keep in mind though is that, although the table is linked into both AutoCAD and Revit, it won’t automatically update when you make changes. Save your fileĪny changes that need to be made to the table/spreadsheet, whether it’s formatting, content, etc. Click anywhere on the drawing area to place the schedule. Navigate to where your AutoCAD file is saved, make sure it’s a DWG file, and select the file.Ĥ. You can find the Link CAD icon on the ribbon under Insert in the Link section. Luckily the hard part is over linking into Revit is very simple. Your screen should look something like this.Įxcel can’t link directly into Revit so a workaround for that problem is to link the Excel file into AutoCAD (as we just did above) and then link the AutoCAD file into Revit. Then use the drop down menu below it to select the data link you just created and hit OK.Ĭlick anywhere in the drawing space to place your table. You can find the table icon under the Annotate tab in the Tables section.
Make sure the path type is set to full path.Ĭheck the Link to Range box and enter the cell range that you found in step 6 in the format of A1:C14 To choose the Excel file you’ll be linking in, click the three dots and find the file. In this case, the cell range is A1 to C14.įlip back over to your AutoCAD file and in the data link dialogue box, enter the following information. Then hit OK on the Data Link Manager dialogue box.įlip back over to your Excel file to check the cell range for the information you’re linking. You can find this under the Annotate tab in the Tables section.Įnter the name of the schedule you’ll be linking in and hit OK. Open a new AutoCAD file if you will be linking the spreadsheet into Revit, but if you’re linking into an existing AutoCAD project, open that project file. now, or you can always come back and edit the table later. You can format the fonts, columns widths, cell merging, etc. Open Excel Spreadsheetįirst you’ll want to open the excel spreadsheet that needs to be linked into your project files.
So if you tend to learn better with pictures rather than videos, see below for a step-by-step tutorial of how to link your Excel schedules into both AutoCAD and Revit. in Excel that need to be imported into Revit or AutoCAD, please see the video below for a step-by-step tutorial of how to safely link your files so they will update from a single source. If you find yourself getting structural schedules from engineers, or have non-Revit-using people at your firm who prefer to write keynotes, room schedules, etc. This might mean duplicate information within a single Revit file across multiple sheets, or duplicate information between different programs. This is something I always try to avoid whenever I can. One of the biggest issues I see in projects is duplicate information. How to Link Excel Spreadsheets into AutoCAD and Revit As soon as you register successfully, this limitation would be removed immediately.
The trial version will reverse the text in some random rows.