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

marsulein wrote:
>
> 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
>
> --
> marsulein
> ------------------------------------------------------------------------
> marsulein's Profile: http://www.excelforum.com/member.php...o&userid=16064
> View this thread: http://www.excelforum.com/showthread...hreadid=557225

--

Dave Peterson