Can't Delete Page Breaks????

[xdollbabyx]

I have an Excel 2007 file that should be around 8 pages long. When I go into Page break mode it is broken in 72 pages. I have inserted NO page breaks. I have used reset all page breaks, that has not helped. It will not allowe me to manually adjust or delete these breaks. When I view the document in Print Preview it shows a modified version of page 1 on all 72 pages and no other information.

I have never seen this before..... HELP??

 

[laczirr]

I am getting the same problem.

We have recently upgraded from excel 2007 to 2010. Now I open a excel file that was created in a previous version and what was once 1 page document is now 12 pages. I am unable to remove page breaks.

I have already tried
Press Alt+F11 (careful, that's ALT+F11)

Press Ctrl+G

Type in or paste in

Code:

Cells.PageBreak = xlPageBreakNoneand hit the Enter key



Then...

Type in or paste in

Code:
ActiveSheet.DisplayAutomaticPageBreaks = Falseand hit the Enter key.

Then...

Press Alt+Q to return to the worksheet.

but I am getting the error
Runtime error 1004
Unable to Set the Page Break Property of the Range Class.

I also tried pasting information into a new document - now i have a page break around EVERY cell

Help!

 

[MVCA]

Hey Everyone,

This is a really old thread but thought I'd mention that the reason the automatic page breaks are not moving is due to the scale setting in PageSetup. Depending upon your circumstances it needs to be changed so that the automatic page breaks allow your manual page breaks to take precedence.

Good luck!

 

[PANDALiciousss]

This worked! Thank you so much

 

[jeffmctague]

This worked perfectly for me. Thanks so much!

 

[jeffmctague]

Now that I followed the instructions to get rid of unwanted page breaks, now I am unable to insert any manual page breaks. Help!

 

[msally65]

What happens if you follow these steps:

Press Alt+F11 (careful, that's ALT+F11)

Press Ctrl+G

Type in or paste in

Cells.PageBreak = xlPageBreakNone

and hit the Enter key



Then...

Type in or paste in

ActiveSheet.DisplayAutomaticPageBreaks = False

and hit the Enter key.

Then...

Press Alt+Q to return to the worksheet.

Any joy?

Thank you internet stranger. I also got the 1004 error, but when I turned my view to normal it worked. You just saved me ditching a heap of work!

 

[Tom Urtis]

Thanks so much for your message.
Amazing how some of these threads evolve over the years.

 

[johndeeredad]

Thanks so much for your message.
Amazing how some of these threads evolve over the years.

I had a similar problem (undeleteable page breaks in a pivot table) but found it was caused by a box mistakenly being checked in the Pivot table field setting. Under Layout and Print, uncheck the box "Insert page break after each item".

 

[Tom Urtis]

Thanks - - good tip!

 

[KompootorUser]

If you have more than one tab accidentally selected the page breaks go nuts. Click only one tab & try again. This ended my brain damage