I have a fairly complicated model that refers to several worksheets. I have
set up 4 scenarios, with approximately 20 cells that change and about the
same number of results cells.

When I use the "summary" button, and select the Scenario Summary option,
everything works fine.

However, EVERY time I select the Scenario Pivot Table Report option, I get
the dreaded "Microsoft Office Excel has encounterd a problem and needs to
close "message. It's consistent and is completely repeatable. I've tried
getting rid of extraneous worksheets and unneeded data, but it hasn't helped.
Could it be a naming problem with cells, tabs, or?

Any thoughts?

Thanks