# Sharedparameter

**URL:** <https://forum.dynamobim.com/t/sharedparameter/104657>\
**Category:** Uncategorized\
**Tags:** dynamo\
**Created:** [September 26, 2024, 7:41am UTC](https://forum.dynamobim.com/t/sharedparameter/104657 "2024-09-26T07:41:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![marwen.rahmeniJDNRY](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@marwen.rahmeniJDNRY](https://forum.dynamobim.com/u/marwen.rahmeniJDNRY)\
**Post date:** [September 26, 2024, 7:41am UTC](https://forum.dynamobim.com/t/sharedparameter/104657/1 "2024-09-26T07:41:43Z")

</div>

Hello  
I tried to create a shared parameter script but the end result is null.  
Thank you

[paramétres partagées.xlsx](https://forum.dynamobim.com/uploads/short-url/qQvn3mkLOJjCzx3XuiobsDnBM7l.xlsx) (15.7 KB)  
[Create Shared Parameters from Excel .dyn](https://forum.dynamobim.com/uploads/short-url/hIxttncNuGgzFcwY9rKWZJSzxh2.dyn) (22.4 KB)

---

<div class="post-metadata">

**Author:** ![Mike.Buttery](https://avatars.discourse-cdn.com/v4/letter/m/b19c9b/32.png) [@Mike.Buttery](https://forum.dynamobim.com/u/Mike.Buttery)\
**Post date:** [October 4, 2024, 1:00am UTC](https://forum.dynamobim.com/t/sharedparameter/104657/2 "2024-10-04T01:00:24Z")

</div>

Hi Rahmeni,

Please read the following post [How to get help on the Dynamo forums](https://forum.dynamobim.com/t/how-to-get-help-on-the-dynamo-forums/4677)

There are know issues with Excel and Dynamo try the alternative _Data.OpenXMLImportExcel_ node (see also [here](https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/Warning-Data-ImportExcel-operation-failed-Could-not-load-file-or-assembly-Microsoft-Office-Interop-Excel-when-running-the-Dynamo-script-in-Revit.html))

Screenshots with information pinned also assists the forum members understand your problem

Also I would look for a Revit add in to transfer shared parameters if that is your intent

Onto your graph…  
The list clean / transpose breaks the information - you will need to fix the Excel

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/1/01cebccd29cca36e883ba452635921d525fc0148.png)  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/d/7d536b7d973f0362cd931d8fc9fb907e7de6e1ac.png)

Looking at the Excel  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/0/20cdb8a1ace29b905af179e474ce481c188181a2.png)  
Repeated names will possibly create multiple shared parameters with different GUIDs  
Fix the blanks

Remove the header (Row 1 in Excel)  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/1/01d7e344868a515451b7c0f260075549a3f73243.png)

This will not work

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/7/97fc1ab57d0c9ab9db07f57fa9f48535a0775ebc.png)  
What I would suggest is that you will need to build some dictionaries  
Example  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/6/26177f0787bee11681043f2a040efa469c685941.png)

Make sure your group names are in the current shared parameter file

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/b/eb5e2e2dbf1ffe67736e10720c0f78920e4f244e.png)

---

<div class="post-metadata">

**Author:** ![marwen.rahmeniJDNRY](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@marwen.rahmeniJDNRY](https://forum.dynamobim.com/u/marwen.rahmeniJDNRY)\
**Post date:** [October 4, 2024, 6:43am UTC](https://forum.dynamobim.com/t/sharedparameter/104657/3 "2024-10-04T06:43:14Z")

</div>

> [@Mike.Buttery](#):
>
> Remove the header (Row 1 in Excel)

Thanks so much
