1. Turn off the "consolidated" view from the toolbar, choose the department you want and click the ExcelDirect button.
2. Just turn off the consolidation and select each department you want to preview.
_________________________
Andrew Bates