Excel Embed iFrame call Refresh all Data Connections

jcummings68 

Hi, 

I have a similar problem. 

Have you ever found an answer for this? 

The problem I am having: 

I put an embed in an html page. 

First it worked completely find and as expected. 

But after 1 week it is now not showing column headers properly. 

See below: 

Issue

As you can see the headers are not visible. 
UNTIL --> I press this:

"Refresh Data Connections"

How it should look(after pressing the above function):

Now obviously I need this to be working correctly from pageload. 

Customers should not have to refresh this (especially on a 450 row file which is shown in one-size-fits-all screen) manually. 

Is there any way to make this work from the start (as it has done in the first week of being there), or is there a workaround to make it refresh these connection on pageload? 

Anyone capable of helping or knows where I should look for this? I tried using additional parameters of the excel workbook sharing. But that got me nowhere. 

Also tried googling for this issue (can't get much further beyond finding this post, and some old video of implementing manual VBA processes (where apparently you can setup an automated process to renew data connections in an excel workbook but this is for excel online so I am not sure if this would even work for my problem).

Thank you for any help anyone is capable of providing.