• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

Cell entries are not printing out in Excel

I have a client whom when they print out spreadsheets in Excel 2010,  The entire spreadsheet print out fine, except for some numerical values in cell.  They are just blank.  This is with all excel docs.  The numerical entries show up in print preview, just not when actually printed.
0
Davester44
Asked:
Davester44
  • 7
  • 7
2 Solutions
 
luconstaCommented:
If you increase the width of that cell will print?... sometimes on screen it seems ok but at printer will need more space (even so it should print "####" if there is no room but I'll give it a try).

Another thing to check - there are some macros in your workbook?... try to open the workbook without enabling macros and see if is printing ok, because you could have a macro that will "hide" that cells before printing and then "show them back" (to understand what I mean see Excel Macro : Hide Cell Content from Printing)
0
 
Davester44Author Commented:
All the values in excel's cell have enough room.  It shows fine on the desktop and fine in print preview.

I went to the macro settings, and 'enable all macros' is selected.  I cannot change this setting with macro's because the selection is greyed out.

Also if I cut and paste all the contents of one sheet to a blank excel document.  Everything will print out fine.  No, this is not a workaround or a viable option.  There are hundreds of excel sheets for this company.

My only workaround at this time is to print to a pdf, and then it will print out correctly.

Another thing that has been recently happening is that the number and lettering are normal size, while the cell blocks are shrunk into the upper left corner, making the sheet totally misaligned.
0
 
luconstaCommented:
This is happening only on a single PC or on all of them?... with other words - if you try print that file from another PC is it ok?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Davester44Author Commented:
It is happening on any PC they try to do it from.  

I believe it to be the properties of the excel file itself. Not a printer issue, since it happens with multiple printers.

It happens when the computer you print from is Xp or 7, Office 2003, 2007, or 2010, but most people are using 2010.

When I cut and paste the spreadsheet to a new document, it prints fine, meaning there is something wrong with the document properties.  Also, with the cut and pasted version that prints fine, I am not able to change the macro settings either - so I'm doubting it's a macro issue.
0
 
luconstaCommented:
One other thing to check: when you "cut & paste" on a new document the size of the columns remains EXACTLY as the original or are modifyed?... I had once an Excel document that on "print preview" shows all perfectly but on the printer were a lot of "####".

Could you do a test by increase the column width with at least 30% to see if is working (even if you said there is enough room in that columns).

Is it possible to attach at least a part of that file to see if the problem is the same on my PC for example?... but make sure you remove any "sensitive data" from that file!
0
 
Davester44Author Commented:
No, there is enough room in the columns. There is no ####.  Everything shows perfect in print preview.  This is happening on any PC we try it from.
0
 
luconstaCommented:
Try open an excel file and "save as" with another name but make sure is XLSX format, and see if this will make any difference.
These files are exported by any chance from "external" programs or were "built" directly in excel?... because I find recently a problem with excel files exported from another application that loose the "red formatting" (and also the sign) for the negative numbers if the file was edited directly immediately after was exported. The "workaround" in that case was to "save it as" excel file because even the application exported an "xls" file it was in fact an "html" one.
0
 
Davester44Author Commented:
I'll try to so a 'save as' with another name, but the excel files are xlsx format.  I would prefer to change the setting in the actual excel file itself though.

If I do the 'save as' and it works, they will have duplicate copies of these files on their shared drive that already has a set limited space, and it will likely get messy.

I will try it for troubleshooting purposes, but in the long run, I need to change a property setting in the actual file.
0
 
luconstaCommented:
Of course is for "troubleshooting" purposes, but in the absence of an attached file I have to do some tests with your help.
0
 
Davester44Author Commented:
I tried the 'save as' with one of these excel files. Same result.  I did a 'save as' and changed the name of the file. I also tried both saving as xlsx once, then tried xls. Same result when printing.  It still looks perfect in print preview though.

I don't know if this is relevant at at, but one of the description fields, say "sugar", or "wheat" for instance, has a value of "=LOOKUP(F15,'C:\WORKSHEET\[New Worksheet.xls]NEW WORKSHEET'!A$1:A$2002,'C:\WORKSHEET\[New Worksheet.xls]NEW WORKSHEET'!B$1:B$2002)"

The other values in the worksheet are just values - the same in the formula field as they are in the cell itself.  Summation fields are just standard summation formulas.
0
 
luconstaCommented:
The formula will not influence the "printing" part, eventually if the worksheet referenced is moved from its place it shoud have an error when opening any file linked to that worksheet but all you should miss is an "updated value" for that field but it should be on paper if you see it on the screen and especially if you said that printing to a PDF it would look corectlty.

This "PDF" thing made me to as you if you try to print to a different printer - you said that different OS'es, different Office versions have same problem but you test it on same printer?... if so I would recommend to test to another printer especially if your "PDF test" was to a "printer like" PDF converter, because even it seems impossible I never say never... :)

And I'll suggest to be as different printer possible (different producer or at least different type - lasser/inkjet).

Another thing to try - if you delete some rows and/or columns from that file (make sure you do that with a copy of the file) so that the "non printing" values will not be in the same position on paper - they will print or not?...
0
 
Davester44Author Commented:
I fixed it.  All the printers that I was printing to were installed from the printer directory.  None of them worked.  I installed one of the printers via IP, installing the driver locally and it worked.

Thanks for the effort Luconsta.  I'll award you some points for making me think in the printer direction.
0
 
luconstaCommented:
Ok, I'm glad to be a little help for you... ;-)
0
 
Davester44Author Commented:
Installing the printer via ip so the printer drivers were installed on the local pc and not coming from the server worked.  I accidentally found this when I tried to print the same document to my printer installed via ip.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 7
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now