Excel Printing Issue
Posted on 2012-09-10
This is a bit of a weird one so I will try to explain it as best I can.
We have a system for improving our products which is unfortunately been coded into a series of excel spreadsheets. When a user does something on one and saves it, it may go away and update several others etc. (should have been a db right?, yes I think so too.)
Anyway, when one user tries to print a spreadsheet from within the system, they click file, print, try to select a printer from the drop down list and none of the details under the drop down list update, (Name, Location, Comment etc) and the spreadsheet behind the print window turns grey.
Once you have selected the printer you want to print to and you click print, nothing prints.
I'm confident that this issue is something to do with the code that is setup within the excel spreadsheets although it only appears to effect one user running xp. (most users are now on Win7 but other XP users can print these fine).
Also, any other spreadsheet we have tried that is not to do with this system allows us to change the printer (and it's details populate automatically underneath) then print no problem at all.
We've tried uninstalling / reinstalling and repairing MS Office. Deleting and remapping printers, new drivers for system and printer, AV scan too.
Now I guess the ideal thing to do would be to upload a spreadsheet so that the code can be viewed by yourselves to help determine a cause perhaps however I am not permitted to do this because of the project that this is.
I would just change his default printer to the correct printer however as this users plots a lot of CAD drawings, he has stipulated that his default printer must be the plotter (and not the HP Printer used for A4 documents & spreadsheets etc). :(
Any pointers in the right direction would be most appreciated.