Page breaks keep moving!

invisigirl · May 15th, 2002, 01:11 PM

I might go insane shortly.

I have a workbook where, every time I open it, the page breaks have moved. I have never seen this happen before, and since there are two worksheets that have to match up in page count (they are just sorted differently) when printed, it's making me absolutely crazy! Added to this problem is the fact that there are black title bars on each page (they're all different, so I can't just repeat one row at the top of each page to correct this), and I have to keep moving them so I can print the dang thing correctly.

What might be causing this? It's the only time I've ever seen it happen, and I'm so annoyed I'm about to start killing small animals.

Help me, please!

invisigirl · May 15th, 2002, 01:24 PM

Okay, I did figure one thing out. It's the bottom margin that is changing. I set it at .8, and it keeps changing back to 1.03.

I guess, now that I know that much, I can just keep changing it back, but why would it not save my margins as I set them? I always save before I close (in fact, I save so frequently, it's almost to the point of OCD!), so this is perplexing. And why just the bottom margin?

There are some things in this world I will just never understand.

James · May 15th, 2002, 01:27 PM

Hi Invisgirl,

Before you kill any small animals,

Just a thought, have you looked at the page setup on the two differant sheets. Are the print areas set the same?

James

invisigirl · May 15th, 2002, 01:31 PM

Oh, yes. It's not just one worksheet where the margin is changing. It's the whole workbook. See, the two sheets matched up when I last closed it. Then I opened it, and they still matched each other, but the page breaks (on both) were misaligned because of the changing margin.

I'm really a pacifist. The animals are safe.

Corticus · May 15th, 2002, 01:32 PM

you could try recording a macro of you setting the page margins like you want on both sheets, then have the macro automatically execute everytime you open the workbook...
my organization used to use QuattroPro 9 which defaults your page settings to scale 120 across by 5 wide, such fun!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 01:11 PM	#1
invisigirl Board Regular Join Date: Mar 2002 Location: Oregon Posts: 130	I might go insane shortly. I have a workbook where, every time I open it, the page breaks have moved. I have never seen this happen before, and since there are two worksheets that have to match up in page count (they are just sorted differently) when printed, it's making me absolutely crazy! Added to this problem is the fact that there are black title bars on each page (they're all different, so I can't just repeat one row at the top of each page to correct this), and I have to keep moving them so I can print the dang thing correctly. What might be causing this? It's the only time I've ever seen it happen, and I'm so annoyed I'm about to start killing small animals. Help me, please!

May 15th, 2002, 01:24 PM	#2
invisigirl Board Regular Join Date: Mar 2002 Location: Oregon Posts: 130	Okay, I did figure one thing out. It's the bottom margin that is changing. I set it at .8, and it keeps changing back to 1.03. I guess, now that I know that much, I can just keep changing it back, but why would it not save my margins as I set them? I always save before I close (in fact, I save so frequently, it's almost to the point of OCD!), so this is perplexing. And why just the bottom margin? There are some things in this world I will just never understand.

May 15th, 2002, 01:27 PM	#3
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Invisgirl, Before you kill any small animals, Just a thought, have you looked at the page setup on the two differant sheets. Are the print areas set the same? James

May 15th, 2002, 01:31 PM	#4
invisigirl Board Regular Join Date: Mar 2002 Location: Oregon Posts: 130	Oh, yes. It's not just one worksheet where the margin is changing. It's the whole workbook. See, the two sheets matched up when I last closed it. Then I opened it, and they still matched each other, but the page breaks (on both) were misaligned because of the changing margin. I'm really a pacifist. The animals are safe.

May 15th, 2002, 01:32 PM	#5
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	you could try recording a macro of you setting the page margins like you want on both sheets, then have the macro automatically execute everytime you open the workbook... my organization used to use QuattroPro 9 which defaults your page settings to scale 120 across by 5 wide, such fun!