page break on every cell

[dunnotar02]

Hi all - I've had some trouble recently when opening
Excel 2002 spreadsheets in Excel 2003. When I go to page
break preview, every cell is surrounded by page breaks,
essentially making every cell one page. I can't reset
the print area to fix this - I have to close out of the
spreadsheet without saving changes. This doesn't happen
when I open the spreadsheet in Excel 2002. It could also
be related to opening the document on a Windows XP
computer (has the problem) vs. Windows 2000 Pro (no page
break problem). Its very odd and makes printing quite
difficult. I have the most recent updates to Excel
2003. Any thoughts?

 

[Dave Peterson]

I've only seen this once in real life--although there have been a few posts in
the newsgroups.

We were in a hurry, so we just inserted a new worksheet, copied the cells and
pasted them to the new worksheet.

Then deleted the troublesome worksheet.

If you're going to do that, you may want to save a copy for experimenting (I
didn't, but should have!).

Maybe changing printers would help.

Maybe select all the cells (ctrl-a twice in xl2003).
Then "Insert|Reset all page breaks" would help.

===
We were either using xl97 or xl2k when I saw this under winNT (IIRC).

 

[Gord Dibben]

Google search brought out that this sometimes happens when Autofit to one page
is set on.

Gord Dibben Excel MVP