# Key Schedule Node doesn't overwrite excel data

**URL:** <https://forum.dynamobim.com/t/key-schedule-node-doesnt-overwrite-excel-data/91472>\
**Category:** Packages\
**Tags:** revit, archi-lab, excel, dynamo\
**Created:** [July 5, 2023, 8:41pm UTC](https://forum.dynamobim.com/t/key-schedule-node-doesnt-overwrite-excel-data/91472 "2023-07-05T20:41:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![boey1219](https://avatars.discourse-cdn.com/v4/letter/b/73ab20/32.png) [@boey1219](https://forum.dynamobim.com/u/boey1219)\
**Post date:** [July 5, 2023, 8:41pm UTC](https://forum.dynamobim.com/t/key-schedule-node-doesnt-overwrite-excel-data/91472/1 "2023-07-05T20:41:26Z")

</div>

Hi, I am having trouble getting this script to overwrite the data from Excel back to Revit Key Schedule. I am using the “Key Schedule Node”

It will write the data its the revit schedule is empty, But If I delete the schedule from revit, which it will lose the key that is assign to each door. So I dont want that…

Thanks in advance!  
[Dynamo Script File](https://drive.google.com/file/d/1hlqC-Livzj3wYJc__qhqLnv38AKK10i9/view?usp=sharing)

[Excel Data](https://docs.google.com/spreadsheets/d/1nLKzoUONpoNk5Xc1n_83rBuP2TynqRCo/edit?usp=sharing&ouid=112343505189781211395&rtpof=true&sd=true)

---

<div class="post-metadata">

**Author:** ![willem.creffierKCWFB](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/willem.creffierkcwfb/32/180663_2.png) [@willem.creffierKCWFB](https://forum.dynamobim.com/u/willem.creffierKCWFB)\
**Post date:** [February 21, 2024, 12:42pm UTC](https://forum.dynamobim.com/t/key-schedule-node-doesnt-overwrite-excel-data/91472/2 "2024-02-21T12:42:36Z")

</div>

Hi @boey1219 , welcome.

I had the same issue.

There is a workflow.

1. Copy the Keyname to a dedicated parameter.
2. Delete all the lines in the Key schedule (not the schedule itself)  
3.Re-import the values of the Key schedule.  
4.Using a dictionary, assign the Keynames again to the elements, using the dedicated parameter as your identifier.

[Element.GetParamtervalueByName for Key schedules - Dynamo (dynamobim.com)](https://forum.dynamobim.com/t/element-getparamtervaluebyname-for-key-schedules/96536/20)

The graph is in the link.

Kind regards,

Willem