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

Lynn Wrote:
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


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=533375