You’re offline. This is a read only version of the page.
I have an excel report that uses odata connections to Dynamics 365 crm. I have set the refresh properties of the connection to refresh every 60 minutes and uploaded the file to One Drive. I find that the auto refresh doesnt happen. Is there a way an excel file with external connections be scheduled to autorefresh in One Drive so that users can access latest data in the file.
*This post is locked for comments
I have the same question (0)
Bimlap I have never done this specifically.
But you may be able to create an excel macro in the report worksheet to execute on open. That macro could be a simple refresh of the data.
Here is similar. But you can search for options.
Share
Report
All responses (
Answers (
1,570
