Forum Discussion

Helper IV

4 years ago

Solved

Power Query in Sharepoint

Hi! Does anyone know a good guidebook, video, etc how to publish Excel workbooks to Sharepoint Online (not SP 2013 etc). Excel workbook uses a Power Query-connection and this workbook needs to re...

Need Help

Tips and Tricks

Tutorial Requests

Anonymous
4 years ago
Hi tuulia ,

Sorry, automatic refresh daily in SharePoint online is unavailable. You can use Refresh when opening or periodically refreshing:

Refresh an external data connection in Excel

Also check out these topics:

Excel web part from list - Autorefresh - SharePoint Stack Exchange

How to autorefresh Pivot table in Excel web access webpart in sharepoint

Also check supported connections and schemes:

Work with external data in Excel Services (SharePoint Server)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.