Part of my cell borders in Excel 2010 don't print anymore!

[calvinb]

I have a form in Excel 2010 that has borders around many of the cells. I used the fine dotted line because the solid line prints out too dark. This was fine for 2 weeks but yesterday, when I printed the form, parts of the borders are missing. There doesn't seem to be any reasoning to it, just bits of the border are there and other parts are missing.

I tried removing the print area and setting it again but it's still the same. If I print without the print area the borders print except around check boxes. It seems like there is an invisible area around the checkboxes that blocks the area around them.
Does anyone have any experience with this. I found a few instances with a Google search but couldn't find a solution!

Thanks

 

[GlennUK]

What type of check boxes? Forms or ActiveX?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[calvinb]

Forms.

I'm using a heavier line now. The borders are all there but it looks terrible because they are so dark!! And around the checkboxes part of the borders are missing so the checkboxes definitely have something to do with this problem.

 

[Larena]

Have you tested printing to a different printer? Some printers will struggle to print very fine lines. It can depend precicely (i.e., to the pixel) where the line is on the page whether the line is printed or not.

 

[colinmitton]

Also you may want to check if the background has change from none to White? I had that messing up boarder printing one and

Another thing you may try is printing with a slightly different driver, i.e. if your current driver is PCL5 try the PCL6 version.

Also double check the printing setting in Excel,in option under advanced try it with / without High Quality mode for Graphics selected. You may also want to check the page setup / Sheet settings too you may have draft or black / white on which can mess things up too.

 

[calvinb]

Larena:
Thanks for the suggestions but I have tried on different printers here and at work but there is no difference. The odd thing is that it used to work on all the printers and I haven't changed the borders but it just stopped printing parts of them.

ColinMitton:
Thank you also for your suggestions. The background is set to "no color". I tried without high quality mode (worse!). Draft and black and white mode are not selected. I don't know how to change the drivers but it used to work on all my printers so I don't see why it would change because of the driver.

Anyway, thanks to both of you for your suggestions. I will continue the search. There has to be a solution!