Solved

Excel 2013 format issue when printing

Posted on 2013-11-05
8
367 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
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
 
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 AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

773 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