Auto-Update Connections In Excel Sheet

Copper Contributor

Hello,

 

I have multiple excel workbooks that other users enter information on. I have a separate excel workbook that pulls information from the other workbooks to display the information. I am trying to set the connections to auto-update every 'x' minutes, but when I try to select connection properties from the Refresh All dropdown under the DATA tab, it is greyed out so I can't select it.

Connection Properties.png

1 Reply

@KyleBaumann 

That means you have no data connections in your workbook. You may check by clicking on Existing Connections icon to the left, under under Connections in This Workbook.