PowerPivotPro's FAQ Site

As you start to develop large workbooks you will likely run into a by-design behavior that will drive you crazy – it did for me! If your workbook grows beyond a single thumbnail snapshot when posting to a PowerPivot Gallery, you will notice that the workbook seems to render in the wrong place, most likely in the bottom right-hand corner of the workbook. You will say “what the heck??” It is rendering in the wrong place. As it turns out, the problem is that when Excel Services renders the workbook, it starts where it was last saved. Normally that is the last thing that you changed in the workbook, which is likely towards the bottom right-hand side of the last screen