Excel Analysis workbook - Updating dataconnections

Help Activities
, ,
1

Excel Analysis workbook - Updating dataconnections

This image shows the ribbon interface of Microsoft Excel with the "Home" tab selected and the "Analysis" tab highlighted. (Captioned by AI)
This image shows the ribbon interface of Microsoft Excel with the "Home" tab selected and the "Analysis" tab highlighted. (Captioned by AI)820×187 11.4 KB

Hello, Is it possible to automate updating all SAP dataconnections in Excel Analysis workbook? The workbook requires Analysis Client for MS Office add-on to be installed (which I have) and that user is logged in SAP and has the needed rights for data queries.

I tried with Excel Process scope > Use Excel File > Refresh Excel Data Connections

But it seemes that this does not recognize the Analysis add-on.

An Excel spreadsheet interface with text highlighted in cell B6 and the 'Automate' and 'Help' tabs highlighted in yellow on the ribbon menu. (Captioned by AI)
An Excel spreadsheet interface with text highlighted in cell B6 and the 'Automate' and 'Help' tabs highlighted in yellow on the ribbon menu. (Captioned by AI)708×232 12.9 KB

Is there some solution for this problem? I appreciate any advises…

2

Hi @ext-o

Refresh excel data connections activity is not working for you.?

3

No it did not. Automation executes that activity without crashing and succeeds to save the file, but I can see that the data was not updated.

This picture is when automation opens the file in Excel Process Scope and I can see that Analysis tab is missing. All the built-in queries relate to that functionality.

An Excel spreadsheet window is displayed, showing the Home tab with various formatting and alignment options, and cell B6 containing the value '921100156. (Captioned by AI)
An Excel spreadsheet window is displayed, showing the Home tab with various formatting and alignment options, and cell B6 containing the value '921100156. (Captioned by AI)708×232 12.9 KB