Excel Embed iFrame call Refresh all Data Connections

Occasional Visitor

Hi all, I have a protected workbook, which is pretty simple in itself. However, when I upload it to my personal oneDrive and then view it, the data is only populated after you either select the dropdown on the 3rd tab, or you click on the "refresh all data connections" at the bottom of the iFrame. Is there some way to call this inside of the embed iFrame? It seems like this should be a pretty easy fix, yet I cannot seem to find one.

 

To see what I mean, please look here: https://huronperthcatholic.ca/covid-19/covid-19-ventilation-improvements/

 

Thanks in advance for your help.

0 Replies