Forums >> Revit Systems >> Technical Support >> EXCEL LINKING REVIT MEP 2012

Agile3100

active

Joined: Mon, Aug 9, 2010
41 Posts
No Rating

Has anyone come up with a way to link and excel file to Revit yet? Making an image is out of the question with how many panelboards we show and way too time consuming. Any ideas are appreciated!

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

There is no excel linking in Revit yet.  You schould be able to schedule your panelboards in Revit.

This user is offline

ralf007

active

Joined: Sat, Nov 12, 2011
4 Posts

a work around is to link it into autocad then link the autocad drawing into revit it works fine

every time the excel is updated you have to open and reload the excel in autocad, then save, then hit reload in the manage tool with revit to update it.

This user is offline

Agile3100

active

Joined: Mon, Aug 9, 2010
41 Posts
No Rating

Can you tell me how you link this into CAD please? Because everytime I link my CAD dwg into Revit I get an ActiveX error suggesting that I explode the excel file or change my proxygraphics to 1, which it already was. I am linking the excel file by paste special. This is the second time that I have seen this suggestion but i have never been able to get it to work. 

This user is offline

ralf007

active

Joined: Sat, Nov 12, 2011
4 Posts

depending on what version of autocad your using

you want to datalink the excel file,

under insert on the ribbon there linking and extraction, or with the command "datalink" after that there a few easy steps to get it loaded into autocad

hope that helps 

This user is offline

Agile3100

active

Joined: Mon, Aug 9, 2010
41 Posts
No Rating

That worked! We were using paste special and linking them that way. Thankyou

This user is offline

MacRowerGT

active

Joined: Mon, Oct 3, 2011
10 Posts

Using Excel 2010I created all of my schedules in one Excel Spreadsheet.  Each Schedule and legend on a different worksheet. I formatted all text to Arial 12.save this within your project folder. 

AutoCAD 20121. Create a New File name it the schedule title2. Home > Table  choose From a data link. Select Launch the Data Link Manager dialog3. Create a new data link,  Name the Link the schedule title.4. Browse for your excel path, full path, select the worksheet and I use the link to range as I can control what fields are imported.5. OK6. OK7, Arrange your tables in CAD as you will want them to appear on your sheet.  It's helpful to create a faux viewport in CAD to help you.  ONce complete you can delete it.8. SAVE FILE

Revit 20121. Open your sheet and select Insert > inke CAD2. Choose you saved DWG file3. Position and SAVE

Done!Now when you update the Excel File, You'll need to update links in the CAD file then you can use Manage Links in Revit to Reload the DWG.

-----------------------------------

Utilizing Revit Building Suite 2014

This user is offline

mhans

active

Joined: Tue, Nov 7, 2006
456 Posts

Just a word of caution. I find in the past that linking Excel to Autotcad was unstable. Now with your link to Revit from Autocad with Excel file that's something really dangerous, especially with a panelboard schedule. I like WWHub to just do your schedule in Revit. Unless you are not really BIMing your world. I guess, Revit has a valid point (somehow) in not linking a common .xls file into it.

-----------------------------------

Motto: "No Post left behind"

This user is offline

EXCEL LINKING!

0

Linking Revit files to Excel

12

REVIT MEP - Separate models for MEP disciplines

5

Why can't Revit and Excel just be friends

1

Import/Linking Excel Sheets into Electrical Components

0