?
Solved

Excel 2013 format issue when printing

Posted on 2013-11-05
8
Medium Priority
?
392 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
[X]
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
  • 5
  • 3
8 Comments
 
LVL 31

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 31

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 31

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 31

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 31

Accepted Solution

by:
gowflow earned 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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.

719 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