Excel printing "additional" blank pages?

[marsulein]

Dear Excel Users,

First of all I am not sure whether should I put this thread under the
programming section because I feel that it has got nothing to do with
programming. Mods: Feel free to move this thread if it is not in the
appropriate section, thank you.

Computer configuration:
OS: WinXP SP2
Office 2003 SP2

I have a 3 pages template, the first 2 pages consist of only words
while the third one has a chart in it. After running through my java
program, it will create X number of pages and each pages will have a
chart. When I opened the file and look at it, there are only 14 pages
(the side scrollbar stopped at pg 14). However, when I tried the Print
Preview, it showed 22 pages. Pages after 14 just consist of blank
page.

After trying a lot of things I found out that it's the problem with the
charts generated by the codes. Because after I removed all of them, the
Print Preview showed the correct pages (14). According to my knowledge,
adding a chart will not automatically add rows right?

FYI, the chart is 17 rows high and 10 columns wide. Adding a chart will
add in additional 2 blank pages when I did a Print Preview.

Any ideas what's wrong or is there any settings that I can set to
prevent this? Thanx in advance!

Regards,
Mar

 

[Dave Peterson]

Charts are included in the print range--unless you do something special--like
set the print range manually.

Select your range to print, then
File|Print Area|Set Print Area

But maybe excel thinks there's more data to print than you do.

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused