View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Lara H. Lara H. is offline
external usenet poster
 
Posts: 3
Default Page breaks shift after preview/setting print pref

Thanks for the response, Dave!

I deffinately hadn't considered the printer aspect of this (so focused on
MAKING Excel obey me! LOL) We have everything from an OSe to HP Laserjet
3700dn here - a true plethra of choices! ::sigh:: ah well... Thanks for the
prompt response and generosity of info! Will keep coming back and seeing
whatever gems of wisdom I can glean. I have a very bad feeling this database
is going to have to move to ACCESS anyway...
--
Always learning,


"Dave Peterson" wrote:

I'm guessing that it's a difference in printers (or printer drivers).

You may want to set those manual page breaks as conservatively as possible.
Find the "worst" printer and make your pagebreak decision based on that printer.

On the nice printers, you may find that you have larger margins, but so what
<vbg.

Lara H. wrote:

I have a small database (16 pages; 659 rows/13 columns) where the page break
consistantly shifts from its forced position (i.e. I have manually placed the
breaks where needed). It is saved with new position intact, etc., but still
shifts when either reopened or after previewing and/or setting printing
preferences. Others opening the workbook from other PC have different page
break settings than mine... What is the user interface error here? :-)
Thanks for any feedback, no matter how embarressing...
--
Always hoping to learn,
Lara :-)


--

Dave Peterson