I have set up a pivot table and want to use the show pages option however the
actual page setup is not preserved when you do this - i.e. I have set up the
first page to print as landscape but the subsequent split out of the table
puts everything as portrait - is there any way the formatting can be
preserved when using this option? (I know I can select all tabs and do a
group edit if needed)