# Link file from dynamo

**URL:** <https://forum.dynamobim.com/t/link-file-from-dynamo/42843>\
**Category:** Revit\
**Tags:** dynamo\
**Created:** [November 6, 2019, 6:48pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843 "2019-11-06T18:48:58Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![farz.pittmeadows](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@farz.pittmeadows](https://forum.dynamobim.com/u/farz.pittmeadows)\
**Post date:** [November 6, 2019, 6:48pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/1 "2019-11-06T18:48:58Z")

</div>

What I am intending to do is the following:

Create a File and Link Several Electrical models  
Use Dynamo to Export Data from all the linked files into one Excel Sheet  
I need to Modify the Excel Sheet and Import the Information Back to the Revit Models.

I know that we can’t write to linked files, so the intention is to open each individual model and import the information relevant to each model from the excel file.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![thiru2jack](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/thiru2jack/32/112308_2.png) [@thiru2jack](https://forum.dynamobim.com/u/thiru2jack)\
**Post date:** [November 6, 2019, 8:44pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/2 "2019-11-06T20:44:46Z")

</div>

@farz.pittmeadows welcome Use basic write excel node for extracting your data from the model.

---

<div class="post-metadata">

**Author:** ![farz.pittmeadows](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@farz.pittmeadows](https://forum.dynamobim.com/u/farz.pittmeadows)\
**Post date:** [November 6, 2019, 8:59pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/3 "2019-11-06T20:59:32Z")

</div>

Thank you. I have already done the Dynamo but i have several issues:

1. If i import an electrical equipment on Revit, I can run the Dynamo and am getting all my result on an excel but when i link an IFC or Revit file to a new project, the excel is empty.

2. I want to modify the Excel and important it to the revit model.

Thank you

---

<div class="post-metadata">

**Author:** ![kennyb6](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@kennyb6](https://forum.dynamobim.com/u/kennyb6)\
**Post date:** [November 6, 2019, 9:15pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/4 "2019-11-06T21:15:08Z")

</div>

If you have a script and have problems with it, please show us the script. Right now you are only telling us what you want and none of are willing to do all the work for you for free.

---

<div class="post-metadata">

**Author:** ![farz.pittmeadows](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@farz.pittmeadows](https://forum.dynamobim.com/u/farz.pittmeadows)\
**Post date:** [November 6, 2019, 9:18pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/5 "2019-11-06T21:18:27Z")

</div>

Thank you for your response but how will i sent it to you as new user can’t upload any file.

---

<div class="post-metadata">

**Author:** ![kennyb6](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@kennyb6](https://forum.dynamobim.com/u/kennyb6)\
**Post date:** [November 6, 2019, 9:19pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/6 "2019-11-06T21:19:00Z")

</div>

You can upload pictures or upload sample files to a third party like dropbox or google drive and paste a link here.

---

<div class="post-metadata">

**Author:** ![farz.pittmeadows](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@farz.pittmeadows](https://forum.dynamobim.com/u/farz.pittmeadows)\
**Post date:** [November 6, 2019, 9:39pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/7 "2019-11-06T21:39:50Z")

</div>

Here the link:

> **[Revit to Excel - Electrical Equipment.dyn](https://drive.google.com/file/d/1_b966QHvFlesfUfmkYGSq5rdwJRd0yrm/view?usp=sharing)**
>
> Google Drive file.

---

<div class="post-metadata">

**Author:** ![farz.pittmeadows](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@farz.pittmeadows](https://forum.dynamobim.com/u/farz.pittmeadows)\
**Post date:** [November 7, 2019, 3:28pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/8 "2019-11-07T15:28:58Z")

</div>

Hi!  
Any update.

Thank you and have a nice rest of your day.

---

<div class="post-metadata">

**Author:** ![Fiesta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/fiesta/32/31914_2.png) [@Fiesta](https://forum.dynamobim.com/u/Fiesta)\
**Post date:** [November 8, 2019, 8:00am UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/9 "2019-11-08T08:00:39Z")

</div>

Hi,

1. Maybe you overwrite the last excel file with the new data.  
Try to create first the new excel file and then select it as your excel file in Dynamo.  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/9/596922e7d415875cd9e3c1394f8ed27f08235dbc.png)
2. If you want to push data back to Revit, then i recommend to also get the unique id (uuid) of every element. With this id you can write data back to revit (rows with data and id need to stay together).  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/d/bdf1c15eeb74ed86c963f5e0fa204ea402592523.png)

---

<div class="post-metadata">

**Author:** ![farz.pittmeadows](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@farz.pittmeadows](https://forum.dynamobim.com/u/farz.pittmeadows)\
**Post date:** [November 8, 2019, 4:12pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/10 "2019-11-08T16:12:24Z")

</div>

Hi,

Thank you a lot. Have a nice day.

Regards,  
Farz

---

<div class="post-metadata">

**Author:** ![Fiesta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/fiesta/32/31914_2.png) [@Fiesta](https://forum.dynamobim.com/u/Fiesta)\
**Post date:** [November 11, 2019, 7:21am UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/11 "2019-11-11T07:21:40Z")

</div>

Could you solve your problem?

---

<div class="post-metadata">

**Author:** ![farz.pittmeadows](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@farz.pittmeadows](https://forum.dynamobim.com/u/farz.pittmeadows)\
**Post date:** [November 12, 2019, 11:21pm UTC](https://forum.dynamobim.com/t/link-file-from-dynamo/42843/12 "2019-11-12T23:21:20Z")

</div>

Hi.

Not exactly, do you have another way?

Thank you.
