ADFS - Sharepoint 2013 - Excel Worksheet - Unwanted password Prompt RRS feed

  • Question

  • Hi Guys,

    we use AD FS Claims as authentication Method for our Sharepoint 2013.

    Now we have one problem. We have a Batch File that opens around 10 xlsm Files that read data from our sharepoint site.

    Since a few days the excel opens an adfs password prompt and asks for login data.

    We tried to add a rule in the AD FS to accept the client ip but its not working.

    How can i tell the sharepoint to use the client ip too as AD FS Claim?

    Or does anyone knows a way to give the xlsm files a specific username in a Makro or VBA Maybe?

    Thats in advance for the answers.

    Monday, November 19, 2018 11:00 AM