does the following help?

print preview.
click setup
choose landscape or portrait
click on "fit to 1 page wide by <blank pages tall"

unless the number of displayed columns is changing all the time it
should look much the same each time you print it, just the number of
pages changes.

..and in the pivot table options untick autoformat if you want.

regards


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=573707