# Dynamic link with Excel

**URL:** <https://community.wolfram.com/t/dynamic-link-with-excel/22635>\
**Category:** Questions\
**Tags:** data-science, external-interfaces, graphics-and-visualization\
**Created:** [August 11, 2023, 8:01am UTC](https://community.wolfram.com/t/dynamic-link-with-excel/22635 "2023-08-11T08:01:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tarpanelli](https://avatars.discourse-cdn.com/v4/letter/t/a4c791/32.png) [@tarpanelli](https://community.wolfram.com/u/tarpanelli)\
**Post date:** [August 11, 2023, 8:01am UTC](https://community.wolfram.com/t/dynamic-link-with-excel/22635/1 "2023-08-11T08:01:03Z")

</div>

Hello,  
I’ve created in my nb a simple dynamic link with excel as following

```
Needs["ExcelLink`"]
v = Dynamic[Refresh[ExcelRead["C7:C20"], UpdateInterval -> 1]]

```

the variable v is updated continuously as per change of excel cells. The problem that I have is to re-use v as a list of number. For example, I would like to plot v in a simple list line plot

```
ListLinePlot[v]

```

but I get the following error

```
ListLinePlot::lpn: {28565.,28565.,28560.,28560.,28560.,28570.,28570.,28570.,28570.,28570.,28570.,28570.,28570.,28565.} is not a list of numbers or pairs of numbers.

```

How can I manipulate v such that I can use it as any other list of numbers?  
Thanks  
Best regards  
Paolo

---

<div class="post-metadata">

**Author:** ![eric3](https://yyz1.discourse-cdn.com/wolfram/user_avatar/community.wolfram.com/eric3/32/12760_2.png) [@eric3](https://community.wolfram.com/u/eric3)\
**Post date:** [August 11, 2023, 2:19pm UTC](https://community.wolfram.com/t/dynamic-link-with-excel/22635/2 "2023-08-11T14:19:02Z")

</div>

You are setting `v` to a `Dynamic` expression. `Dynamic`s are special “objects” that display things in the front end. `ListLinePlot` won’t work with such objects–it needs a list of points. To fix this, you need to put the assignment inside the Dynamic:

```
Dynamic[v = Refresh[ExcelRead["C7:C20"], UpdateInterval -> 1]]

```

---

<div class="post-metadata">

**Author:** ![tarpanelli](https://avatars.discourse-cdn.com/v4/letter/t/a4c791/32.png) [@tarpanelli](https://community.wolfram.com/u/tarpanelli)\
**Post date:** [August 11, 2023, 2:29pm UTC](https://community.wolfram.com/t/dynamic-link-with-excel/22635/3 "2023-08-11T14:29:50Z")

</div>

thank you.  
it works
