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. UGH!
Fortunately there is a simple workaround, always navigate to the upper left-hand cell (A1) prior to saving the workbook. Thus the last location will be on the top screen. And you worksheet will render as you expect in both Excel Services and with the generation of the thumbnail. After a while it just becomes second nature. I don’t even think about it anymore, except when I see a newsgroup posting on the topic from time to time.
Recent Comments