Excel 2010 - Sheet with Macros and VB Script having issues after upgrading from Excel 2003

Posted on 2012-09-12
Last Modified: 2012-09-18
We have upgraded from Excel 2003 to Excel 2010.  There is a very complicated sheet that has a lot of macros with VBScript attached to it that worked fine in 2003, but now in 2010 Excel we have issues that we cannot get to the source of.

The biggest issue now is, during a print preview, if we do a shrink to fit, when we come back to the page to print it, the sheet has every page set as a page break.  (This is with a network print queue selected).  If we do the same thing with Adobe PDF Creator set as the printer, we can shrink the sheet to print on 1 single page without issue, and when we get back to the sheet to print, we do NOT get the page break issue.  Currently, this is our workaround, printing to PDF, then opening the PDF and printing the PDF from within Adobe reader.
Question by:jkeegan123
    LVL 17

    Accepted Solution

    As you have identified in your question, this is most likely a printer driver problem.  Did you also have an operating system update when you upgraded Office?  I have had problems of this sort quite often, especially with postscript drivers - try to make sure you have the most up-to-date drivers if you can.
    LVL 5

    Author Closing Comment

    Issue was the print driver PLUS firmware update of the print server.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now