Excel Help Requested

[DukieInKansas]

We recently upgrade our Microsoft Office to 2010. Excel files that used to print borders now no longer print the thin line borders in all locations. It will print double lines and thick lines but not thin lines on a page. On another page in the same workbook, it will print all the lines. I have tried repairing the installation of Office and that didn't correct the problem. I was working off a file that printed all the lines last month. Once I renamed the file and entered the new data, it no longer printed the lines. Any suggestions?


eta - we did upgrade from a very old version of Office. Now I'm wishing we hadn't.

[DukieInKansas]

Just to make it more interesting, a file that printed all lines/borders a few weeks ago no longer prints all the lines/borders. It will print thick lines and double lines but no other lines.

[DukieInKansas]

Another piece of the puzzle. If you save it as a PDF file, the lines will print.

[bluebutton]

I am useless regarding your question however I wanted to say that learning 2010 after years with 2003 has been a ridiculous PITA and I wish you the best. Seems like every time I use office, I have to google how to do something that was quick and easy in the previous version.

At this pt, I'd recommend you just save everything to pdf and print from there. Save yourself the time -- you've got one working way of doing.

[DukieInKansas]

I am useless regarding your question however I wanted to say that learning 2010 after years with 2003 has been a ridiculous PITA and I wish you the best. Seems like every time I use office, I have to google how to do something that was quick and easy in the previous version.

At this pt, I'd recommend you just save everything to pdf and print from there. Save yourself the time -- you've got one working way of doing.

Unfortunately, saving to PDF changes the margins and I don't like the way it looks on the page.

Have you discovered that you can set up your own tab/ribbon menu and put the commands you want on the ribbon? That made me happier with 2010.

[fordgrl00]

DinK, I am so glad you posted this, I have the same problem...Grrr. I thought it may have been because of the way my company installed the update recently also that caused it. I have not been able to figure out any rhyme or reason as to why sometimes it will print and sometimes it will not. Or, one worksheet will and the next will not. It's nice to know I am not the only one with this issue. It drives me crazy. Or I send the file to a co-worker and they can print it fine. One thing I tried recently was saving it after I have it formatted to print and then close it. When I go back in it seems to print fine. Its a stupid work around though. Being able to format the ribbon is nice but I really liked the '03 software, plus 2010 seems really really slow when opening or saving a file.

If you find out a solution please share, Excel has become my new worst best friend lately.

[OZZIE4DUKE]

I keep expecting DA to weigh in with a solution, even though she may still be out on maternity leave (???) At least I'm sure she has access to the insiders who are working feverishly on a fix for this problem...

DA?

[DukieInKansas]

DinK, I am so glad you posted this, I have the same problem...Grrr. I thought it may have been because of the way my company installed the update recently also that caused it. I have not been able to figure out any rhyme or reason as to why sometimes it will print and sometimes it will not. Or, one worksheet will and the next will not. It's nice to know I am not the only one with this issue. It drives me crazy. Or I send the file to a co-worker and they can print it fine. One thing I tried recently was saving it after I have it formatted to print and then close it. When I go back in it seems to print fine. Its a stupid work around though. Being able to format the ribbon is nice but I really liked the '03 software, plus 2010 seems really really slow when opening or saving a file.

If you find out a solution please share, Excel has become my new worst best friend lately.

From visiting the Microsoft knowledge base, we are not the only ones with this issue. I've tried the solutions suggested but they don't seem to help. I have repaired MS Office, I have saved the file as and HTML and then put it back to Excel (suggested for 2003), I've checked my print driver, I've stood on my head while chewing gum and saving the file, etc. The print driver sounds logical but since the worksheet printed 3 weeks ago but not now and a different worksheet in a different file changed from printing to not printing borders within 5 minutes. What a pain!

[DevilAlumna]

I keep expecting DA to weigh in with a solution, even though she may still be out on maternity leave (???) At least I'm sure she has access to the insiders who are working feverishly on a fix for this problem...

DA?

Yeah, sorry -- not my area of expertise at all... I'm just as stumped as y'all.

I would have guessed the print drivers too, but sounds like that's not the case for DinK. The other thing I'd check is make sure you've actually got borders, and just aren't expecting the gridlines to print.

If it really is a known issue for Excel 2010, perhaps the Service Pack 1 has an update/fix for it; I think SP1 was released earlier this spring - Windows Update should pick it up.

And I am still out on maternity leave -- yay!

[DukieInKansas]

I keep expecting DA to weigh in with a solution, even though she may still be out on maternity leave (???) At least I'm sure she has access to the insiders who are working feverishly on a fix for this problem...

DA?

Yeah, sorry -- not my area of expertise at all... I'm just as stumped as y'all.

I would have guessed the print drivers too, but sounds like that's not the case for DinK. The other thing I'd check is make sure you've actually got borders, and just aren't expecting the gridlines to print.

If it really is a known issue for Excel 2010, perhaps the Service Pack 1 has an update/fix for it; I think SP1 was released earlier this spring - Windows Update should pick it up.

And I am still out on maternity leave -- yay!

Thanks, DA. I know it isn't your area of expertise.

Just an FYI, on the worksheets where the thin borders don't print, the gridlines won't print either. I'm now going to try uninstalling and reinstalling Office to see if that helps. Will also reinstall any updates. I'll keep everyone posted.

Enjoy your maternity leave. Babies are fun!

[DukieInKansas]

For those of you playing along at home - removing and reinstalling Office 2010, with all current updates, did not solve the problem.