Multiple pages after printing selected area

I have a spreadsheet with a number of sheets, including a sheet with a set of
charts. I update the spreadsheet which updates the charts and then select
the chart area and go to print just this selection. However, when I return
to my spreadsheet it has turned my other sheets into mutliple pages (they are
originally resized to landscape to 65% to fit to one page) which is a pain to
resize back again (especially if I don't check in print preview or page setup
first). The file is relatively small (under 500k) and has no other
"funnies". Any clues why this might be happening and how to stop it
happening?
Thanks Lynn

Lynn,
I can't replicate the problem but here are some workarounds:
a) Save the file before selecting and printing the charts, then close without saving.
b) Make sure that multiple sheets aren't selected when you do the print
c) You can apply the same Page Setup to multiple sheets by selecting all the sheets you want to change.
Clive

Originally Posted by Lynn

I have a spreadsheet with a number of sheets, including a sheet with a set of
charts. I update the spreadsheet which updates the charts and then select
the chart area and go to print just this selection. However, when I return
to my spreadsheet it has turned my other sheets into mutliple pages (they are
originally resized to landscape to 65% to fit to one page) which is a pain to
resize back again (especially if I don't check in print preview or page setup
first). The file is relatively small (under 500k) and has no other
"funnies". Any clues why this might be happening and how to stop it
happening?
Thanks Lynn