Joined: Mon, Mar 30, 2009
- There isn't an easier way to do this, which I'm suprised about as excel is a much used tool linking data to drawings so if there is an easier way please let me know. I've seen on here creating an image file, which is time consuming and doesn't live link the data whereas this method does.
This method involves linking excel to CAD then linking CAD to Revit. Open up CAD and follow these steps:
To set up Data Links:
Launch the TABLE command.
Click “From a data link
“, and launch the “Data Link Manager
” by clicking the button (illustrated).
Click “Create a new Excel Data Link”
Name the Data Link â€“ something intuitive.
Browse for your Excel Table
The “New Excel Data Link”
dialogue can be expanded by clicking the
button in the bottom right corner.
Under “Cell Contents”,
uncheck “Convert data types to text”,
and check both “Retain Formulas”
and “Allow writing to source file”.
Checking those options will make it so your Excel formulas will be preserved, and that you will be able to make edits to the table in AutoCAD, and they be populated to the origional Excel file.
Press the [Ok] button 3 times to get out of the command, and insert your linked table.
- Assuming you checked the “Retain Formulas” option when setting up the Data Link, you’ll notice fields (text with a grey background) for any calculated value.
After inserting your Excel table, any updates made in the source Excel file will be updated in AutoCAD. By default however you will not be able to update data from AutoCAD, and have it update in the source Excel document. To modify a table value in AutoCAD, select a cell, right-click, and navigate down to “Locking”, and select “Unlock”.
After unlocking a cell, you can click into a cell, change a value. As a deliberate checks and balances, to update the Excel file, you must right-click once again, and select “Write Data Links to External Source“.
To pop it into Revit, just link the CAD file by:
Hope this helps!