page breaks everywhere

[gemmavine]

hi,
i have been working on a spreadsheet and now there are page breaks everywhere. if i try and move them, they just reset and stay the same.
i do not understand why this is happening but i need to remove them in order to print.

regards
gemma

 

[swaink]

Hi Gemmavine

What version of Excel are you using please?

Kevin

 

[gemmavine]

Hi

2007.

Regards

Gemma

 

[Sanjeev1976]

I faced such a problem once or twice and the best way I could find is to set the print area once again by selecting the area and then changing the page settings as per requirement.

Sanjeev

 

[gemmavine]

i have reset the print area, but the page breaks do not disappear.
its really frustrating!
Thanks anyway

Gemma

 

[Sanjeev1976]

If the file is not confidential, send it to me on sanjeevrjain@gmail.com and I'll see if I can help.

 

[gemmavine]

Hi

Unfortunately, the file is confidential. Thank you anyway for your responses, really appreciate your help.

Gemma

 

[hallingh]

I'm assuming you've tried simply resetting all of the page breaks? Can you save a copy of your workbook and change the actual contents to make it not confidential but keep the troublesome page breaks intact so we can try to fix them?