1

What are the requirements to be able to update data that came from Sharepoint (using Export to Excel button) by Excel "Refresh All" button?

On some machines I can refresh (when authentication prompt ask credentials everything works ok) , and in some not (when authentication prompt ask credentials, the credentials are not accepted. Excel prompt appears again and after a new try a error message appears), both with the same user (administrator).

I want to be able to refresh data in all machines and I dont know if I need to Install something in every machine to do this.

Sorry for the Google Translator English.

1

The repeating credential prompt may be a symptom of a missing trust between client and server. I would suggest to add the domain of the SharePoint to the Local Intranet security zone.

  1. Run inetcpl.cpl in your Windows 10 search or with Windows Key + R. This opens the Internet Options.
  2. Click the security tab and select Local Intranet.
  3. Then click on Sites and Advanced.
  4. Type in the URL of your SharePoint and click Add.
  5. Click Close and then on OK to save this new setting.
  6. Close the Internet Explorer and try to open the file.

If this helped you can enroll this setting with group polices on every or specific clients in your network.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.