Hi, Lisa,
I just tried again using * (consolidated) and only the 3 sheets in my statement (I only have 3 and selected all 3 for use in the statement group) were exported to Excel. The Name of the Sheet is perhaps misleading as it shows that I selected Consolidated, where some statements had actually had the department code Hard-Coded into them but you can adjust a statement sheet title to offset that. I've also done this using 9.0D(120207).
Now, if I select 'All Departments', that's a different story. That prints many statements for each sheet depending on the number of departeents used in my dataset. This is also how that option is meant to work.
_________________________
Regards,
Softrak Tech Support