[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

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

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.
0
jkeegan123
Asked:
jkeegan123
1 Solution
 
andrewssd3Commented:
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.
0
 
jkeegan123Author Commented:
Issue was the print driver PLUS firmware update of the print server.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now