Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service.Translate
@dbrownG4VN3: Trust me, you don't wanna go that way. Importing Excel in Revit is kinda useless, as you could only import cell data (raw data), no formulas, and only in some specific manner that Revit would understand. It is possible to create Revit schedules, export it to Excel, and create a bi-directional link between exported schedules and Revit data. Something like a Graitec extension or a CoBie extension. That would work.
Linking Excel as an OLE object in Revit doesn't seem very useful. The more Excel tables you link as OLE in Revit, the slower the Revit file will become. I do it all the time in Autocad, inserting dozen tables as OLE slows down Autocad file considerably and increases dwg size dramatically.
P.S. If you really need some text-based table (no formulas) in Revit, you can create a Revit schedule with some text parameters as instance parameters. Those parameteres would be like the columns in Excel. Then, you can give any text values to each instance for each row as you like.
Everybody wants to insert or link Excel files directly into Revit. Because each company has some sorts of excel balance sheets set up in their own custom ways for various reasons: cost estimations, time projections, area totals and area balances. Many architects and engineers need "bear-metal" time & costs projections, they don't invest design time and resources into design phases or design options. Complex solutions needs to be checked or validated by simplified excel formulas.
Linking Autocad tables is not the best solution, as Autocad doesn't support advanced math functions as Excel does. E.g roundup , xlookup, etc
In AutoCAD, it is possible to link an Excel Spreadsheet to a drawing, open said spreadsheet from AutoCAD via OLE, make edits to it IN EXCEL, and then the spreadsheet in AutoCAD is updated with the new information when the Excel file is saved...
THIS IS WHAT I WANT
My company lists out system classifications and labeling methods used in the field using a simple Excel Spreadsheet. I want to link this spreadsheet into my Revit file so that I can put this spreadsheet into our Sheets that are eventually printed for construction documents. Why is this a hard thing to do? I don't want to import data. I don't want to import formulas. I just want to link a simple spreadsheet into Revit so that the data in the spreadsheet is visible in Revit and updated whenever the spreadsheet is updated. I feel like this is not a difficult task, and I may even try to make a simple Revit add-in that will do this.
