I have been working in excel 2003 for several years now and have a large
number of spreadsheets that use pivot tables. I have just installed excel
2007 and started to create a pivot table but do not like the way it is
visually displayed. I have dragged/put 2 fields into the row label, in 2003
these would show side by side but in 2007 one is above the other? and to
make thing more confusing there seems to be a line sperating the 2 but not
between the next record (if that makes sense).

Is it possible to change the style to how it looked in 2003?

Thanks

Yes it is, all of your questions are explained in detail on video no. 5 over
here (the video titled: "improving the appearance of the pivot table, making
it more comprehensible")

http://www.free-training-tutorial.com/pivot-table.html



--



"The Rook" wrote:

I have been working in excel 2003 for several years now and have a large
number of spreadsheets that use pivot tables. I have just installed excel
2007 and started to create a pivot table but do not like the way it is
visually displayed. I have dragged/put 2 fields into the row label, in 2003
these would show side by side but in 2007 one is above the other? and to
make thing more confusing there seems to be a line sperating the 2 but not
between the next record (if that makes sense).

Is it possible to change the style to how it looked in 2003?

Thanks