Excel Read Issue If It Has Auto Refresh Enabled In The Pivot Table

News Knowledge Base
1

How to troubleshoot error 'Read API source Excel scope: Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))' ?

Issue Description:
In using Excel, both manually and also in Automation, you might encounter issues while refreshing data within the sheet at the same time as code is trying to access the Excel file. This often occurs when reading an Excel file that has auto-refresh enabled for the pivot table.

Error: 'Read API source Excel scope: Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))' ?

Below are different workarounds for different scenarios:

Issue #1: Error when Opening the Sheet using Excel Application Scope

Why this is caused: An error occurs while trying to open the sheet using Excel Application Scope.

Resolution: Instead of using Excel Application Scope for the read operation, use a workbook activity. This will open the Excel file and refresh the data therein.

Issue #2: Error while Using VB.Net Code to Activate a Sheet.

Why this is caused: An issue arises when using VB.Net Code to bring a particular Excel sheet into focus or to activate it.

Resolution: Add a read-range activity at the end and read the sheet that needs to be put into focus. Following this, add a save workbook activity. This method ensures that a specific sheet is brought into focus without encountering any issues.

Another approach to avoid these issues entirely is to utilize the 'Refresh Pivot Table' activity in the Modern Activities. It offers a more robust and streamlined way of managing and refreshing data in Excel, therefore minimizing potential errors.

Remember that these are workarounds, not ultimate solutions, and the appropriateness of each workaround can be determined based on the specific situation and requirement.

Conclusion:
Understanding the crucial role of Excel Application Scope and its interaction with refreshing pivot tables can be integral in avoiding such issues. These simple workarounds can save a considerable amount of time and effort when working with Excel files programmatically.

It's always best to check your code and ensure you're not trying to access the Excel sheet simultaneously with a refresh command or activity.