WHY ARE SOME OF MY GRIDLINES NOT PRINTING IN EXCEL 2007 INSTALL
I also needed to install service pack 2 for Office 2007 as 2007 had a known problem handling. If I print or print preview with a single worksheet, the problem does not occur.Ģ) I tested the same spreadsheet in Excel 2007 on a different machine (running XP 2002 SP3 and a different printer) and the problem did not occur.ģ) I tested the spreadsheet on a different system running Excel 2010 (XP 2002 SP3) with a different printer and the problem still occurred.Ĥ) I removed Office 2010 from my development machine and installed Office 2007 and this fixed all problems (see other problems below). None of these fixed the problem.ġ) This problem only happens if I print or print preview with more than one worksheet selected. I tried the suggested fixes above (unhide objects, repair, hot fix and printer drivers). I also have two controls that move significantly upwards (as they are well down the sheet), suggesting that the movement is actually proportionally up and left (each time I do a print or print preview). Each time I repeat the print or print preview the size gets smaller and the controls move further left. My development system is Vista, Office 2010 and a Cannon MP830 printer.Īs described above if I do a print or print preview the controls get smaller and move left. Note, I upgraded straight to 2010 not via 2007. xlsm I encountered a number of problems with these controls, including the problem described above.
On upgrading to Excel 2010 and converting the file to an. It contains a number of List Boxes, Scroll Bars and Drop Down boxes. I have a spreadsheet originally created in Excel 2002. I have provided some detail below about the problem and what steps I took to analyse and fix in the hope that this may help resolve the problem in Excel 2010. This fixed all the problems I was having. The only way to fix the problem for me was to move back to Excel 2007 (with service pack 2). I tried all of the suggestions above (unhide objects, repair, hot fix and printer drivers) and these did not work. #3 Most if not all the boxes on the left side of the sheet that have borders (dotted line borders) don't print, which is not a big problem as I have found that if I change the line type they do print correctly. Again I can't find where I can change how large the text prints. #2 there is a drop down box for (cell A,9) next to the text "cabinet Type" and this text prints larger with this version of office over the 07 version. The above mentioned problem is not the only problem I am having,I feel I should mention them as maybe all of these problems may be connected or not. I am sure this problem will get more attention once my customer upgrades to 2010 office, currently they feel it is my problem, because they can't simulate the problem on their 2007 excel 32x system. This problem is costing my company $$$ if you (by that I mean myself or co-workers) fail to save the document before printing, and then close the file and don't save it after printing.Īfter printing several pages of the document become un-recoverable (without unprotecting the tab and manually moving and re-sizing every checkbox which there is 30 of these checkboxes), and you have to delete the tab and re-do the work. Thanks Sally but the answer to our problem really isn't answered. Since the first posting, the problem is not just with print preview, the problem also occurs if you print without previewing the document.
Not exactly a straight forward message, however I have come to expect that.
The hotfix said "there are no products affected by this package installed on this system".
0 kommentar(er)
