Printing worksheet

[jbob1]

I use Excel (Office X with OS 10.3.7) to keep track of employee
attendance. I have about 6 workbooks set up with any where from 5 to
80 sheets per workbook (depending on the department). I also have a
master sheet with generic information on it. These worksheets are on a
flash drive.

The last time that entire workbooks were printed was around the middle
of February with no problems. An occassional sheet may have been
printed between now and then but I don't recall for sure.

I went to print something today and none of the sheets will print
except the master sheet. If I copy a worksheet to a new workbook it
prints fine. Other spreadsheets and documents seem to be printing fine
so I figure the print drivers are installed correctly. The computer
that these are printing from was just changed from an iMac to a Mac
Mini but I can't think that is the issue.

Any suggestions? Thanks.

 

[JE McGimpsey]

I went to print something today and none of the sheets will print
except the master sheet. If I copy a worksheet to a new workbook it
prints fine. Other spreadsheets and documents seem to be printing fine
so I figure the print drivers are installed correctly. The computer
that these are printing from was just changed from an iMac to a Mac
Mini but I can't think that is the issue.

First, check your print area for the sheets that aren't printing - is
that range set correctly?

How are you trying to print - grouping sheets? one-at-a-time? Does the
"printing page x of y" dialog show up? Do you get errors, or just
nothing?

What happens when you attempt to print preview?

Your workbooks may have become corrupted, but it would seem incredible
that 6 workbooks were corrupted at the same time without having been
exposed to a macro.

Moving from the iMac to the Mini, as you suggested, shouldn't have
anything to do with the problem.

 

[Bill W]

I'll mention it only because you didn't ... you are selecting "Entire
Workbook" in the "Print What" radio button options, correct?

 

[jbob1]

Sorry - I am not crazy and do try to troubleshoot before I ask
questions. I'm just getting back to this today. I brought that flash
drive to my computer today (an iMac G5 running 10.3.8) to try some of
your suggestions. I opened the workbook, I made absolutely no changes
and tried to print. What I tried, printed without a hitch. How odd -
so I took it back to the Mac mini and guess what - it printed without a
hitch. Absolutely nothing was changed from last week when I first
wrote about this!!!

I apologize for not being more specific before in regards to your
questions above - but it appeared as though everything was operating as
it should. I was only trying to print one worksheet not a whole
workbook. When I did a print preview it showed on the screen. When I
tried to print, the regular print screen came up, the dialog screen
would flash "Printing 1 of 1" then go away but the printer icon never
came up on the dock. There were no error messages - it just seemed to
disappear into space. There are 4 printers in this office - 3
different HPs and a Kyocera Mita and it did the same thing when trying
to print to any of them.

We'll see what happens when we actually have to print again but I would
say that for whatever reason , the problem appears to be solved.

As an FYI - I did have a similar thing happen when I put some new iMac
G5s at secretaries desks. It took a while but I traced that to a
corrupt font. Anything that was typed in Bookman would not print and
exhibited non-printing issues as above. As soon as I changed the font
it printed fine. So that was one of the first things I tried with this
problem and it didn't make a difference.

Thanks for the suggestions though!