Hi,
I have a project in which there is an Excel file in SharePoint. This Excel file is connected to SAP BW. It needs to be refreshed every day.
I have already read some of the articles published in the BP Community about SharePoint and refreshing an Excel file. For SharePoint it is suggested to use SharePoint Mapping, Microsoft Graph API, HTTP request etc. and for Excel refresh it is suggested to use Autocalculate action from Excel VBO.
I prefer to use SharePoint Mapping to open the Excel file with File Management VBO and refresh the Excel file connected to SAP BW without downloading the file from SharePoint. My question is whether the autocalculate action of the Excel VBO works for the purpose of SAP BW refresh? And does the refresh work without downloading the file to the local drive?
Moreover, I am open to any other ideas from you.
