I have an excel file that have a data connection with sharepoint list. I want my excel file to be automatically update when something changes on my Sharepoint list. So in excel I choose:
Data > Connection Properties
and there I saw option 'Refresh every x minutes` grayed out.
How can I turn it on?
Or maybe there is another possibility to auto refresh excel file when item is changed or created on my SharePoint list?
Edit: To create my excel file I exported list from my SharePoint site using option: 'Export to Excel' and it created a new excel file with connection