Page Break Problem

[Roger Fink]

I have one particular Excel file that I can't get to accept horizontal or
vertical page breaks. When properly highlighted, the drop down Insert menu
will indicate a page break is installed at a particular column or row
("Remove Page Break"), but the break doesn't appear in Page Break Preview,
also Print Preview shows the whole file on one sheet. One possibility may be
that the file is pretty long horizontally, ending at column CA, by 70 rows
high. On the other hand I have another spreadsheet 160 rows high and never
had a problem, so maybe length/width is not the problem.

Is this a known bug in Excel 97? If so, is there a way to fix it?

Running fully patched Excel 97 on W2K Pro.

 

[Dave Peterson]

I haven't used xl97 in quite a while, but when you do File|Page setup, what do
you see on the Page tab?

Do you have "Adjust to..." or "Fit to..." checked?

If you have "fit to..." checked, then I think excel will use that setting--no
matter what you've done with page breaks.

 

[Roger Fink]

Yes, that was it exactly. Thanks very much.

I haven't used xl97 in quite a while, but when you do File|Page
setup, what do you see on the Page tab?

Do you have "Adjust to..." or "Fit to..." checked?

If you have "fit to..." checked, then I think excel will use that
setting--no matter what you've done with page breaks.