That would be nice, but we don't have Access
BrianB wrote in message ...
Must be done in a worksheet in Excel.
I suppose you can do it, because there is an option in the setup wizard
to use "multiple consolidation ranges". You don't get as much layout
flexibility though. Pages are possible. The final table cannot exceed
certain limitations, as with any PT.
I would link to an MS Access table in this scenario.
---
Message posted from http://www.ExcelForum.com/