Read Devarajan from Microsoft's response from here --> http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/45d6a242-b501-44c9-aec0-1032a38f07eb

"

this seems to be a feature limitation in PowerPivot, We haven't provided custom impersonation capabilities as it's always current NT...