Error for certain users when refreshing data in Excel
Hello. I have and Excel workbook that is connected via OData feed to Acumatica. I have no problem refreshing the data as needed and have others that are able to refresh the data, however I have a few users that get the following message when refreshing. I've tried to change the authentication settings to no avail. I don't think it's security because I've had them log in with credentials I know work on my machine but then do not on theirs. We are on the same version of Excel and the same security rights in Acumatica. I've checked the URL they have entered and it all matches. Any thoughts? Error below:
[Expression.Error] 'implementation' isn't a valid OData.Feed option. Valid options are:
ApiKeyName, Concurrent, EnableBatch, ExcludedFromCacheKey, FunctionOverloads, Headers, IncludeAnnotations, IncludeMetadataAnnotations, MaxUriLength, MoreColumns, ODataVersion, Query, Timeout
Never experienced this myself, but could you try these?
1. Go to the DATA tab in Excel and click on the Connections icon.
2. Find the connected query(ies) that are having the error
3. Click on the Properties button to the right.
4. Under the first section called "Refresh control", check the box labeled "Refresh data when opening the file"
Option 2 - On premise only
Make sure the account you're using has at least SQL read permissions, otherwise this error will be thrown.
Thanks guys. I tried option 1 to no avail, going to try option 2. Here are the version screenshots. What is weird is if the one that doesn't works creates the spreadsheet, gets data, saves and sends to me, I can edit and refresh without problems. They are then able to refresh the data without an issue. Only happens when I create the spreadsheet adding the OData feed.
I just started reading about CORS. That may have nothing to do with it, but I'm left stumped.