I recently ran across a SharePoint issue that prevented the generation of a thumbnail of workbooks in my PowerPivot gallery. First of all i use the blog post of Dave Wickert Troubleshooting Gallery specific issues to debug my problems. Using this I found a solution to the following problem:
In a few installations where I created a new web application using a hostheader, the PowerPivot thumbnails turned into red crosses.In my case the reason for this was that the GetSnapshot.exe is unable to reach the SharePoint gallery. In all these cases the Site was unreachable from within IE on the server console as well. Disabling the loopback check in SharePoint (http://support.microsoft.com/default.aspx?scid=kb;en-us;896861) resolved the issue and the Snaphots are generated ok again.
I had this problem.
I didn’t get any thumbnail on my PP Gallery but Excel Services was working correctly.
Finally, I could find how to fix this problem.
Under Home -> Site Settings -> Site Collection Administration -> Site Collection Features I found the setting “PowerPivot features Integration for Site Collections”. I had this setting Deactivate, I switched it on and PP Gallery showed me its fireworks!!.
It was then when I could see the GetSnatpshot.exe utility working and I saw its tracing on my ULS Logs.
Good luck with yours.
Great, thanks for posting the solution here.