topic Re: Disappearing Gridlines in Excel 97/XP Pro in Operating System - Microsoft

Disappearing Gridlines in Excel 97/XP Pro

Ben Adams_1 — Thu, 28 Aug 2003 14:28:57 GMT

We have 2 printers: LaserJet 4 Plus, LaserJet 5 SI.
Same computer, same Excel 97 file.
On the 5SI, the gridlines print.
On the 4 Plus, the gridlines don't print.

Different computer, different Excel 97 file.
Same printers.
On the 5SI, the gridlines print.
On the 4 Plus, the gridlines don't print.

Different computer, different Excel 97 file.
Same printers.
One the 5SI, the gridlines print.
On the 4 Plus, the gridlines print.

No settings changed, No change in the printers. This just started happening.

Any ideas?

Re: Disappearing Gridlines in Excel 97/XP Pro

Jay Bollyn — Thu, 28 Aug 2003 20:10:18 GMT

Ben,

Reduce the printing resolution from 600dpi to 300dpi. If the gridlines print fine at 300dpi, you need to add more printer RAM.

Win2k (and especially winxp) need more printer RAM than win9x.

Crucial.com is a good source of printer RAM.

Please let us know.

:-) Jay

Re: Disappearing Gridlines in Excel 97/XP Pro

Jose Antonio Orozco — Fri, 29 Aug 2003 15:04:56 GMT

If you have Office97,
did you installed Office 97 Services Pack 1&2?

Re: Disappearing Gridlines in Excel 97/XP Pro

Jose Antonio Orozco — Fri, 29 Aug 2003 15:13:47 GMT

also about RAM :
assure the amount of RAM configured in the pc/server matches the amount installed on printer.
Depending in which windows flavor you made the tests, check
a) if you need consider some "reserved memory" not reported to windows (it would be up 1.75 Mb in these models).
a practical value is reserve 1mb for 4Mb installed on a 4plus
b) Page Protect setting in windows could help too

Re: Disappearing Gridlines in Excel 97/XP Pro

ben cabie — Wed, 08 Oct 2003 18:24:10 GMT

i am having the same problem. i have the same setup, a laserjet 4 plus and a 5si. excel gridlines print on the 5si but not on the 4plus. i tried printing in 300dpi but the gridlines still do not print. any ideas?

Re: Disappearing Gridlines in Excel 97/XP Pro

Cynthia Garfold — Thu, 23 Oct 2003 06:55:28 GMT

if this just started happening. I would try updating the drivers for the 4plus. They have been known to corrupt for no reason

Re: Disappearing Gridlines in Excel 97/XP Pro

Roger Faucher — Thu, 23 Oct 2003 07:37:16 GMT

Try adding memory! See: http://www.ec.kingston.com/ecom/configurator/modelsinfo.asp?SysID=+1788+&distributor=0&submit1=Search

HTH

Roger

Re: Disappearing Gridlines in Excel 97/XP Pro

ben cabie — Thu, 23 Oct 2003 11:20:26 GMT

cynthia,

you are correct, i updated the driver a couple weeks ago and it worked...

Re: Disappearing Gridlines in Excel 97/XP Pro

Roger Faucher — Thu, 23 Oct 2003 11:25:36 GMT

Ben:

Perhaps Cynthia should be awarded some points even though you independently solved the problem. She still put out the effort and provided the right answer.

Just a thought!

Roger

Re: Disappearing Gridlines in Excel 97/XP Pro

ben cabie — Thu, 23 Oct 2003 11:29:35 GMT

sure, i am not sure how the point system works but cynthia should get maximum points for putting in the effort and replying when she did not need to...

Re: Disappearing Gridlines in Excel 97/XP Pro

Roger Faucher — Thu, 23 Oct 2003 12:14:19 GMT

Ben:

On her post, if you click where it currently shows , it should reveal a list of possible assignments. Select the one you want to assign, then click somewhere in the white space to de-select the field (or you could inadvertently change the value with the wheel on the mouse). Then click the SUBMIT button near the bottom of the screen. Click the browser REFRESH button to see if it "took". Occasionally, it needs to be done more than once to work.

HTH

Roger

Re: Disappearing Gridlines in Excel 97/XP Pro

Roger Faucher — Thu, 23 Oct 2003 12:16:08 GMT

Ben:

Actually, the button you click at the bottom is labelled SUBMIT POINTS. Sorry!

Roger

Re: Disappearing Gridlines in Excel 97/XP Pro

ben cabie — Thu, 23 Oct 2003 12:18:01 GMT

roger, i see why i can not give her points..i am not the person who actually did the original post...it is another ben...sorry guys but i tried...

Re: Disappearing Gridlines in Excel 97/XP Pro

Roger Faucher — Thu, 23 Oct 2003 12:19:48 GMT

Oops!

Well I hope the other Ben is happy!

Roger