Oct 03 2019 11:19 AM
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.
Oct 03 2019 01:30 PM
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.