Excel 2007 Scenario Summary

I am trying to produce a Scenario Summary, using Excel 2007. I want it to be on its own worksheet. However, when I try to produce it, I get the message that it must be on the active sheet. However, the tutorial that I am following has it on its own worksheet. Any ideas what I am probably doing wrong? Thanks!