linking excel workbooks on share point

Copper Contributor

hi 

 

I am trying to link excel workbooks which sit in the shame file on SP, once linked I want the link data to automatically update once the source data is change 

 

I followed this link How to Link Excel Workbooks (4 Effective Methods) - ExcelDemy and successfully linked my two work books  see below, however when i change the source data the hit "load refresh" nothing happens 

 

Arronzakjones_0-1658495222775.png

 

any ideas why this is occurring please ???

 

Thanks 

 

Arron 

 

0 Replies