PowerPivot for Excel 2010 - Table Import Wizard - Advanced Properties - Security


  • Dear All,

    This might be a silly question. But what does the properties mean and how are we supposed to use it? (Or where are we supposed to find any help/documentation for those?)

    1, Authorization Token.

    2, Cookie.

    And related questions to be confirmed by gurus.

    3. Is that only Windows, Basic and Anonymous Authentication are supported currently? How about Forms Auth? What is the situation of Excel 2013?

    Thanks very much!



    Tuesday, August 27, 2013 1:40 PM


  • Hi, Ed,

    Thanks for asking. I did manage to get Basic working with my own C# code, but in general yes this is still an open question, I would like to see a Sample code/Tutorial on how to make Cookie / Token work. What amaze me is that given PowerPivot is there for Office 2010/2013, with those magic Advanced settings, nobody bothered to have any kind of Help file/F1 or online stuff. I hope this is not due to limited head count in the team?

    Best regards,


    Saturday, September 21, 2013 5:49 PM

All replies