Excel Refreshing data issue

Question

question

pgohbs-0999 asked May 4, '22 emizhang-msft commented May 9, '22

Excel Refreshing data issue

We have multiple Excel files that we use for reporting. Until today they worked fine but now when we try to refresh data we get this error:

"An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"

When we run Excel as administrator, the data refresh works fine, however we have permissions locked down so not everyone that needs to access/update reports can be elevated to admin.

office-excel-itpro

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-05-05T07:03:29.007Z

emizhang-msft answered May 5, '22

Hi @pgohbs-0999,
What kind of data source are you connecting?
Which authentication method are you using?
How did you create the connection?
As you said if you run as an Administator, you can refresh without problem.
I suggest you check if this related to the connection authentication or the system login permission.
please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-05-05T19:51:20.277Z

pgohbs-0999 answered May 5, '22 emizhang-msft commented May 9, '22

What kind of data source are you connecting?
MS-SQL Server database

Which authentication method are you using?
AD

How did you create the connection?
I'm not sure: the Excel files predate me. What's a good way to get at the information you're looking for from an existing spreadsheet?

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft · May 09 at 09:33 AM

Hi,
What version of Excel are you using? If you're using Excel 365, you can go to Data tab and check the Existing Connection, Connection Porperties...- Queries & Connections:

0 ·

image.png (29.5 KiB)

question