I have two large, static files identically laid out that must be combined into a pivot table. I've tried the multi-range selection in the wizard, but the result gives "dummy" field buttons (such as Row, Column, Page, Data) rather than the "real" field buttons (ie., the column headers). How to create a pivot table with all this data using the real field buttons?? Thanks very much in advance.