Page Break/Print Preview Issue

Greetings,

It' has been quite some time since I posted any questions. I have a tough one...

An end-user is running Excel 2003. She has a spreadsheet with a few simple SUM formulas, a few fonts, some formatting, etc. But overall, it's a fairly simple page. No pivot tables, links or complex formulas.

The problem has to do with printing/formatting. I she opens the sheet, she can get it to fit on one letter-size page, landscape format at about 70%, with plenty of white area around the border on the page. BUT, if she changes one cell, anywhere on the sheet, 2 page-break lines appear bisecting her document into quadrants. At this point, its hopeless to try to get rid of the lines. If she tries to drag them, it wants to scale it to 10% or smaller. If she tries to reset the print area, it still shows the lines.

In short, there is only one way to get rid of the offending page break lines; save the document then reopen it. Now it will print on one page without the extra page breaks.

Any ideas on how to resolve this issue? Any help would be much appreciated.

Brian

Originally Posted by teylyn

Some ideas, nothing concrete, but worth a try

- Insert - Name - Define: If there is a range called Print_Area, select and delete it
- Tools - Options - View tab - uncheck "Page breaks" in the section labelled "Window Options"
- check that the size of the paper is correct, maybe somebody changed it to some odd custom stamp sized format by mistake


HTH

Thank you very much. I'll give it a try.

Brian