Problem with PageSetup & Printing

[Mike H]

I have a workbook which was created by a macro, and evry time I try and
print (or Print Preview) it crashes right out of excel. It works fine if I
haven't changed any of the PageSetup properties, but then it prints on loads
of unnecessary pages. It is the same on all the windows & Office 2000
machines at work, but has no such problems on my XP Machine at home.

I am at the end of my patience with this and if anybody can help me solve it
I'll give them a kiss or shake their hand (whichever is appropriate).

Thanks

 

[Dave Peterson]

When I see things like this, the first thing I suggest is to look at the printer
driver.

Either point at another printer (just installing a driver would be a good
test--you don't have to have the physical printer).

If that works, visit your printer's site for new (or fresh) version of your
driver.

Sometimes, this fixes it.

 

[BrianB]

Perhaps you made it it with the XP machine ?
Excel is not easily forward compatible. It is best to work on the
oldest version when newer versions should run it too.