Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Operating System - Microsoft
cancel
Showing results for 
Search instead for 
Did you mean: 

Disappearing Gridlines in Excel 97/XP Pro

Ben Adams_1
Occasional Visitor

Disappearing Gridlines in Excel 97/XP Pro

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?
If it has wires, Ben is responsible
13 REPLIES
Jay Bollyn
Honored Contributor

Re: Disappearing Gridlines in Excel 97/XP Pro

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

check Facebook
Jose Antonio Orozco
Frequent Advisor

Re: Disappearing Gridlines in Excel 97/XP Pro

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

What is not backed up, it not exists
Jose Antonio Orozco
Frequent Advisor

Re: Disappearing Gridlines in Excel 97/XP Pro

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
What is not backed up, it not exists
ben cabie
Occasional Visitor

Re: Disappearing Gridlines in Excel 97/XP Pro

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?
Cynthia Garfold
Frequent Advisor

Re: Disappearing Gridlines in Excel 97/XP Pro

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

Re: Disappearing Gridlines in Excel 97/XP Pro

ben cabie
Occasional Visitor

Re: Disappearing Gridlines in Excel 97/XP Pro

cynthia,

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

Re: Disappearing Gridlines in Excel 97/XP Pro

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
Make a great day!

Roger
ben cabie
Occasional Visitor

Re: Disappearing Gridlines in Excel 97/XP Pro

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...
Roger Faucher
Honored Contributor

Re: Disappearing Gridlines in Excel 97/XP Pro

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
Make a great day!

Roger
Roger Faucher
Honored Contributor

Re: Disappearing Gridlines in Excel 97/XP Pro

Ben:

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

Roger
Make a great day!

Roger
ben cabie
Occasional Visitor

Re: Disappearing Gridlines in Excel 97/XP Pro

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...
Roger Faucher
Honored Contributor

Re: Disappearing Gridlines in Excel 97/XP Pro

Oops!

Well I hope the other Ben is happy!

Roger
Make a great day!

Roger