when consolidating in one xls (eg ConsOfRegions.xls) having several tabs
(north, south, east,) using category method (ie. with several common row
names) I see that when pressing the "2" in top left hand corner of spread
sheet to expand the consolidated totals to display the corresponding cource
rows on the separate tabs, the file name appears eg "ConsOfRegions" rather
than the row being labled as the name of the source tab eg"South, East, North
etc"

How does one get the correct source ie tab anme as the raw name?

Kai Albrecht