Solved

Excel 2013 format issue when printing

Posted on 2013-11-05
8
382 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 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
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 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

756 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