RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

328 Users Online (159 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

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

Search this ThreadSearch this Thread | Page 1 of 1 |

Tue, Nov 1, 2011 at 11:39:06 AM | EXCEL LINKING REVIT MEP 2012

#1

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

 

Tue, Nov 1, 2011 at 2:02:51 PM | EXCEL LINKING REVIT MEP 2012

#2

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 359 Votes


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


This user is offline

 

Mon, Nov 14, 2011 at 6:09:45 AM | EXCEL LINKING REVIT MEP 2012

#3

ralf007


active

Joined: Sun, Nov 13, 2011
4 Posts
5 Stars: 1 Votes


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

 

Fri, Dec 9, 2011 at 6:18:24 PM | EXCEL LINKING REVIT MEP 2012

#4

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

 

Thu, Dec 15, 2011 at 5:30:16 AM | EXCEL LINKING REVIT MEP 2012

#5

ralf007


active

Joined: Sun, Nov 13, 2011
4 Posts
5 Stars: 1 Votes


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

 

Thu, Dec 15, 2011 at 3:39:42 PM | EXCEL LINKING REVIT MEP 2012

#6

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

 

Wed, Dec 28, 2011 at 8:54:06 PM | EXCEL LINKING REVIT MEP 2012

#7

MacRowerGT


active
MacRowerGT Avatar

Joined: Mon, Oct 3, 2011
10 Posts
No Rating


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

 

Wed, Dec 28, 2011 at 9:06:20 PM | EXCEL LINKING REVIT MEP 2012

#8

mhans


active

Joined: Tue, Nov 7, 2006
456 Posts
3 Stars: 10 Votes


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. Smile


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

Motto: "No Post left behind"

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

EXCEL LINKING!

Revit Building >> Technical Support

Mon, May 8, 2006 at 1:19:56 PM

0

Linking Revit files to Excel

Revit Building >> Technical Support

Wed, Jan 22, 2014 at 9:30:36 PM

12

REVIT MEP - Separate models for MEP disciplines

Revit Building >> Technical Support

Tue, Jun 25, 2013 at 6:45:42 PM

5

Why can't Revit and Excel just be friends

General Discussion >> Wishlist

Mon, Dec 21, 2009 at 4:17:40 PM

1

Import/Linking Excel Sheets into Electrical Components

Revit Systems >> Tips & Tricks

Wed, May 20, 2009 at 2:45:53 PM

0

Site Stats

Members:

1513581

Objects:

21255

Forum Posts:

151244

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 1.8353

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights