Excel spreadsheet woes


  #1  
Old 02-19-15, 07:23 AM
E
Banned. Rule And/Or Policy Violation
Thread Starter
Join Date: Apr 2013
Posts: 155
Received 0 Upvotes on 0 Posts
Excel spreadsheet woes

If I make a spreadsheet in Excel on my Windows 7 Pro machine, then print it, about 10% of the working cells don't print. If I e-mail the file to myself, and print it (from an XP machine) everything is fine.

How do I fix this?
 
  #2  
Old 02-19-15, 07:26 AM
Norm201's Avatar
Member
Join Date: Sep 2013
Location: United States
Posts: 10,956
Received 721 Upvotes on 640 Posts
Are you highlighting the cells you need printed? Check your orientation. Check the magnification. Reduce your margins to minimal. Are both versions of Excel the same on both machines?
 
  #3  
Old 02-19-15, 07:38 AM
czizzi's Avatar
Member
Join Date: Jul 2007
Location: USA
Posts: 6,541
Received 15 Upvotes on 13 Posts
Go to page break preview from the drop down menu and see where the page margins are. You can adjust the margins by dragging them to a bigger area. Most likely, the print range needs adjustment.
 
  #4  
Old 02-19-15, 09:45 AM
S
Group Moderator
Join Date: Oct 2004
Location: WI/MN
Posts: 19,125
Received 1,263 Upvotes on 1,204 Posts
What 10% is not printing?
 
  #5  
Old 02-19-15, 09:50 AM
Norm201's Avatar
Member
Join Date: Sep 2013
Location: United States
Posts: 10,956
Received 721 Upvotes on 640 Posts
The part that isn't part of the 90%. Smart a** that I am.
 
  #6  
Old 02-19-15, 10:49 AM
W
Member
Join Date: Feb 2006
Location: USA
Posts: 6,395
Received 63 Upvotes on 55 Posts
Printing

Are the non-printing cells along the the right side or the bottom?
We want to help you.
 
  #7  
Old 02-19-15, 11:00 AM
XSleeper's Avatar
Group Moderator
Join Date: Dec 2004
Posts: 27,061
Received 1,910 Upvotes on 1,716 Posts
Besides checking your print area and margins...

When you press print, it should take you to an excel print options page. One of the settings, the bottom one, on my computer, (just below margins) is the default setting, "no scaling". But the drop down menu also includes "fit to page" if you so choose.
 
  #8  
Old 02-20-15, 03:55 AM
E
Banned. Rule And/Or Policy Violation
Thread Starter
Join Date: Apr 2013
Posts: 155
Received 0 Upvotes on 0 Posts
'Sorry about leaving out that detail...

It's a random "10%". Not a left row, right row, whatever.
I could have a column or row with cell, cell, blank, cell, blank, cell, cell, etc...anywhere on the page.
 
  #9  
Old 02-20-15, 05:07 AM
czizzi's Avatar
Member
Join Date: Jul 2007
Location: USA
Posts: 6,541
Received 15 Upvotes on 13 Posts
Sometimes the column width is too small/tight to print the contents of the cells and you end up with a blank. Are you using two different printers, one for the Win 7 machine and a different one for the XP machine? In XP you are also probably opening the spreadsheet in an older version of excel. That may account for some of the discrepancies. I have an XP laptop and I have a converter so that I can open newer versions of excel in my older program.
 
  #10  
Old 02-20-15, 05:46 AM
Norm201's Avatar
Member
Join Date: Sep 2013
Location: United States
Posts: 10,956
Received 721 Upvotes on 640 Posts
I don't know what happened to my last post. It disappeared. But I was asking pretty much what Czizzi is asking. What versions of Excel are you using?
 
  #11  
Old 02-20-15, 06:38 AM
G
Member
Join Date: Nov 2007
Location: MI
Posts: 2,364
Upvotes: 0
Received 2 Upvotes on 2 Posts
Nobody has mentioned Print Preview?
WYSIWYG

Probably just a default formatting difference between versions. Ticking "Fit to Page" as mentioned should fix it.
 
  #12  
Old 02-20-15, 07:26 AM
P
Temporarily Suspended
Join Date: Jul 2008
Location: NY
Posts: 10,265
Upvotes: 0
Received 0 Upvotes on 0 Posts
How is the printer connected to each machine? Is it connected to the XP box by USB cable & then shared to the Win 7 box over the LAN or is it connected wirelessly, to one of the computers? Look at the spool settings too. Match the printer settings on Win 7 to the settings on XP.
 
  #13  
Old 02-20-15, 07:40 AM
E
Banned. Rule And/Or Policy Violation
Thread Starter
Join Date: Apr 2013
Posts: 155
Received 0 Upvotes on 0 Posts
Both computers have Excel 2002 (SP3). They share the same printer through a server.
 
  #14  
Old 02-20-15, 07:43 AM
S
Group Moderator
Join Date: Oct 2004
Location: WI/MN
Posts: 19,125
Received 1,263 Upvotes on 1,204 Posts
Excel 2002? Seriously? That program would be seven years younger than the OS where it's failing (Win 7 was 2009). I think it's time to upgrade your software (both OSs and Office) to something more current and supported.
 
  #15  
Old 02-20-15, 07:48 AM
P
Temporarily Suspended
Join Date: Jul 2008
Location: NY
Posts: 10,265
Upvotes: 0
Received 0 Upvotes on 0 Posts
What about the printer settings? Do they match?
 
  #16  
Old 02-20-15, 08:30 AM
E
Banned. Rule And/Or Policy Violation
Thread Starter
Join Date: Apr 2013
Posts: 155
Received 0 Upvotes on 0 Posts
Printer settings look identical. (Basically; "auto")

Stickshift, I'm not disagreeing with you. But HQ is too cheap to invest in an upgrade.
 
  #17  
Old 02-20-15, 08:37 AM
P
Temporarily Suspended
Join Date: Jul 2008
Location: NY
Posts: 10,265
Upvotes: 0
Received 0 Upvotes on 0 Posts
"Basically" doesn't count. You have to look more closely than that. The spool settings don't have an auto option.

Create a spreadsheet on XP & print it from Win 7.
 
  #18  
Old 02-20-15, 09:58 AM
E
Banned. Rule And/Or Policy Violation
Thread Starter
Join Date: Apr 2013
Posts: 155
Received 0 Upvotes on 0 Posts
I'm just an average computer user. Tell me what detailed information you're looking for, and where do I find it?


and XP to Win7 worked perfectly.
 

Last edited by EliasMcDaniel; 02-20-15 at 10:30 AM.
  #19  
Old 02-20-15, 01:24 PM
P
Temporarily Suspended
Join Date: Jul 2008
Location: NY
Posts: 10,265
Upvotes: 0
Received 0 Upvotes on 0 Posts
Tell me what detailed information you're looking for, and where do I find it?
My guess is that the problem is in the printer settings. The reason is that the same spreadsheet printed on the same printer has a problem on one machine & not the other. One possible difference between the machines could be the printer settings. On XP, click start, printers & faxes, right click on the printer & left click on properties & the advanced tap. Spool print documents so program finishes faster is checked & so is start printing immediately.

On Win 7, click start, devices & printers, right click on the printer & left click on printer properties & the advanced tab. Are the same things checked? If they are, you can change the settings to see if that helps.
 
  #20  
Old 02-21-15, 05:59 AM
T
Member
Join Date: Jul 2006
Location: Euclid, Oh
Posts: 349
Received 4 Upvotes on 4 Posts
It could also be Font related - Fonts on XP may be slightly different, especially if the original document selected was not standard or available on the second machine. Excel will substitute.
 
  #21  
Old 02-23-15, 08:20 AM
E
Banned. Rule And/Or Policy Violation
Thread Starter
Join Date: Apr 2013
Posts: 155
Received 0 Upvotes on 0 Posts
Pulpo, the settings are exactly the same. Just for giggles, I'll change them to print directly instead of buffer and see what happens.

Tribe Fan, both machines are set for the same font. Just for giggles, I'll change them.

(Yes, I'll be giggling a lot)

11:45 We have a winner! The Windows 7 machine has "font issues". I changed it three times, and it printed perfectly for 2 of the 4 fonts. Who would have thunk it? (XP was fine throughout.)

Thanks
 

Last edited by EliasMcDaniel; 02-23-15 at 08:46 AM.
  #22  
Old 02-23-15, 11:06 AM
T
Member
Join Date: Jul 2006
Location: Euclid, Oh
Posts: 349
Received 4 Upvotes on 4 Posts
Can you tell us what Font was original to the spreadsheet created in XP , and what you chose to make it work on Win 7?
 
  #23  
Old 02-23-15, 11:22 AM
E
Banned. Rule And/Or Policy Violation
Thread Starter
Join Date: Apr 2013
Posts: 155
Received 0 Upvotes on 0 Posts
Sure.

Originally Tahoma.

'Switched to Lucida Console. No good.

I found that Times New Roman and Microsoft Sans Serif worked. Then I yelled "eureka" and quit experimenting.
 
  #24  
Old 02-23-15, 01:42 PM
Norm201's Avatar
Member
Join Date: Sep 2013
Location: United States
Posts: 10,956
Received 721 Upvotes on 640 Posts
You should be able to save the spreadsheet with fonts specific for that file.
 
  #25  
Old 02-24-15, 04:47 AM
P
Temporarily Suspended
Join Date: Jul 2008
Location: NY
Posts: 10,265
Upvotes: 0
Received 0 Upvotes on 0 Posts
Test everything with Courier New 12.
 
 

Thread Tools
Search this Thread
 
Ask a Question
Question Title:
Description:
Your question will be posted in: