Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel 2013 format issue when printing

Posted on 2013-11-05
8
372 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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

840 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