Excel error with page breaks

[klp]

I've been getting an error in excel occasionally that I've never seen before...

Excel will set the page breaks to print one cell per page, i can not
duplicate the issue but it probably happens once per day. A message pops up
on the screen that says "margins do not fit page". once i click "ok" to shut
the message, anything i press makes that error pop up. I can't reset the page
breaks, reset the margins, or do anythign else related to page setup. If i
have it in page break preview, i can see the blue page break lines that
surround every cell.

I'm not usually trying to print when this happens. Sometimes i'm not even
working on the document, just have it open in front of me. It happens with
multiple documents, not even just ones that i've made or that have been made
within my company.

The only fix i've found when i get the error is to save my documents, shut
down Excel and re-open everything. Then the page breaks are set properly and
everything prints just fine.

Has anyone ever heard of this or have any suggestions?
I'm running Excel 2003 SP2

 

[Candice Erdmann]

I had never heard of this, but one of my colleagues was having a similar issue today. The print area insisted on either being 4 pages or 10%, when moments before the worksheet had been printed at over 50% on a single page. Your solution of quitting out of Excel and re-opening the workbook seems to have fixed the problem. Thank you for your post.