Solved

Excel 2013 format issue when printing

Posted on 2013-11-05
8
359 Views
Last Modified: 2013-12-12
Hello,

A user with Excel 2013 is having an issue printing excel spreadsheets that were created in an earlier version of excel, 2003, 2007, and 2010. She is able to open the excel file and the print preview shows normally, but when she prints it out, see attached scans of how it is printing.

If she creates the excel sheet with 2013, there are no issues. Also, tried to print to different printers. I opened the older version of the excel sheet and copied and pasted the content to a new excel sheet within 2013 and saved that, and it printed ok. She receives numerous excel spreadsheets through email for her job, and needs to be able to just print them out as sent. This issue doesn't happen with word, only excel. Please assist!

Thanks!
Shannon
Test.pdf
Scan0907.pdf
0
Comment
Question by:ITLighthouse
  • 5
  • 3
8 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39626587
could you post that file ??
gowflow
0
 
LVL 1

Author Comment

by:ITLighthouse
ID: 39627806
Hello, we tried multiple excel spreadsheets. I have attached an example of one that we tried.
equip-request.xls
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39627912
I have Excel 2003 and prints just very normally.
I would suggest following:

On the culprit machine or where you are getting problems
1) Make sure all updates of windows and office are installed to latest updates and service packs
2) After all updates try if problem persist if yes then uninstall Excel then re-install it and see if it solves it.

gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39627925
I scanned the printed document and here it is.

I would also suggest try uninstalling the printer and re-installing it.
gowflow
Scan.pdf
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:ITLighthouse
ID: 39628087
She has Office 2013, not 2003. We tried multiple printers, and Windows is up to date.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39628093
So it is question of compatibility. What she need to do is the following:

1) open blank Excel 2013
2) load the Excel 2003 file in 2013 via the file Open
3) Save the workbook and choose file type Excel 2013 workbook (I do not have 2013 but it will save it as extention .xslt if no macro and .xlsm if with macro.
4) close the workbook and excel
5) run the newly created workbook the one wit hthe extention .xlst or .xlsm and try the print

gowflow
0
 
LVL 1

Author Comment

by:ITLighthouse
ID: 39628444
Thank you for your reply. I attempted the above steps trying to save as Excel Workbook, or the Excel Workbook with macro enabled. Same issue. I also attempted to delete the printer and re-add it. Is there a compatability pack for Office 2013?
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39628635
you may want to check the last comment on this thread
http://community.spiceworks.com/topic/290240-excel-printing-issue-rdp

gowflow
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Find word and 6 digit number 22 100
Hiding column macro 10 28
Why doesn't duplicate values work on this spreadsheet? 6 38
Excel Hyperlink Question 4 33
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now