Solved

Excel 2007 - Default Row Height Problem 14.4

Posted on 2011-02-21
8
1,526 Views
Last Modified: 2012-05-11
I have an Excel problem with viewing and printing documents from Excel.    

PROBLEM

The exact same document will view and print differently on two separate PC's.  At the bottom of one document (see screenshots) there is a large white space at the bottom while on another PC there is no space and the document fits the page perfectly.   We don't want the large space to appear.  

Please, note that I have compared every page setup and print setting such as margins,  page percentage, DPI setting and they are the exact same.  


WHAT I'VE FOUND  

This issue occurs on multiple machines and setups randomly in my company.    What I have noticed is is the following.    The PC's seem to render/present row height in excel differently.   I noticed the main difference between the PC's is the default row height in excel.  

The PC's that render the document with the large white space have a default row height of 14.4 when a blank workbook is created in excel.  

The PC's that render the document correctly, filling the page completely,  have a default row height of 15 when a blank workbook is created in excel.  

WHY ARE THE DEFAULT ROW HEIGHTS DIFFERENT?

It seems like 15 is the true default row hight within Excel.   Although, it can depend on the font type and size used within the cell.   I am using the same font/size on both PC's.

I have no idea why some machines show 14.4 but feel that this is directly related to my original problem of displaying the excel document correctly.  


ATTEMPTED FIXES

I have tried changing many settings,  uninstalling and reinstalling MS Office 2007.     Trying different Office service packs but the problem continues to happen on the PC's.   Even after completely re imaging the laptops they still show the problem,  while others of the same make/model do not.   This issue also spans across different models of our Lenovo laptops.  


PC DETAILS

Lenovo T500 or T510  - both have 15" displays
Windows 7
Office 2007 SP2  (SP1 shows the same issue on the problematic, 14.4, PC's)
Same additional third party software installed both (comes from an  image we deploy)


Sorry this is such a long question.   It is a complex and weird one that is driving me crazy.  Any suggestions or help would be appreciated.


print-preview---default-height--.png
print-preview---default-height-1.png
0
Comment
Question by:rjpaw
  • 5
  • 2
8 Comments
 

Expert Comment

by:WeBMartians
ID: 34945154
...just some thoughts about fonts (yes, I saw your note about ensuring that the fonts were identical)...

1- Even when uninstalled and reinstalled, document templates sometimes persist: they too would set a font (not exactly default but acting that way).

2-  The automatic row height can vary for different fonts even though the selected font size is the same.

3- All of this default height stuff was introduced with Office 2007: that does seem to be what you are using. For Office 2003, all bets are off.

4- The default font for a fresh installation is Arial 10 point (row height of 12.75 ... I think that's 17 pixels).

5- Finally, see if there are any .XLT files in the StartUp directory. If such are present, they could be modifying the defaults.

...hope this helps...
0
 

Author Comment

by:rjpaw
ID: 34945385
Thanks for the reply.  

3 - Yes we are using Office 2007 on all PC's

4 - I've seen that information posted on the web,  however, the default that our PC's all have is Calibri 11.   If I switch it to Arial 10 and type in a cell, the row height continues to be 14.4.  

5 - I have checked all of the XLStart directories that I could find but none have a template file.   My PC(which has the 14.4) did have a file called Aofrmlfn.xll file that I believed is used with an add on.   However, removing it and restarting the application does not change anything.      On that note,  I've disabled any add-ins that I knew were used with some of our third party software.     Issue still persists.  

Any other ideas?
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34945724
rjpaw,

Try the macro below.

To install a sub in the ThisWorkbook VBA code pane:

1) Press ALT+F11
2) Find the workbook name in the VBAProject window (CTRL+R if it's not visible), and below it you will see 'This Workbook' - double click on it
3) Copy and paste the code below into the 'This Workbook' VBA code pane
4) ALT+F11 to return to the worksheet.
5) Save and close the file

When the file is next opened the Workbook_Open sub will run automatically and will set the row height in all the worksheets to 15 - change the value to suit your requirements.

Hope that helps

Patrick

Private Sub Workbook_Open()
Dim ws As Worksheet

For Each ws In Worksheets
    ws.Cells.RowHeight = 15 'set value to whatever works correctly
Next ws

End Sub

Open in new window

0
 

Author Comment

by:rjpaw
ID: 34945909
Thanks for the reply.  

I understand what your Macro is trying to do.   Basically just a fancy select all across all workbook sheets to set the row height value to 15.    I've tried this manually but it still does not fix my problem.    

As you'll see in the screenshots below.   Although they now have the standard 15 row height.   The machine that originally had the row height of 15 still appears longer than the machine with a default height of 14.4.    The 15 PC actually now stretches off onto a second page.   Thats why you won't see the page number at the bottom (which is not in a footer).

I just don't get it.   The file is identical.   I literally open it on one machine and then open it on the next.  



14.4-PC---Macro-Applied.png
15-PC---Macro-Applied.png
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 45

Expert Comment

by:patrickab
ID: 34945961
rjpaw,

Two points if I may:

1. >I've tried this manually but it still does not fix my problem.

What does fix the problem?

2. I suggest you use MWSnap for screenshots as I'm afraid yours are illegible. You can get MWSnap free from:

http://www.mirekw.com/winfreeware/mwsnap.html

Patrick
0
 

Accepted Solution

by:
rjpaw earned 0 total points
ID: 34946964
I figured it out.   Thanks everyone for your suggestions.   The discussion got me going down the right track.    

I started thinking about font size and if a font could be different on two PC's.    All of the sudden it hit me.   The PC's showing the problem were using the "make font larger or smaller" feature found in the Windows 7 Display control panel.  

The PC's with the 14.4 row height were using the 125%  while the PC's with the 15 height were using the regular 100% setting.     When I changed the setting back down to 100%  it also rendered the problematic document mentioned in the correct way..

I wish I would have though about it earlier.   We have seen problems from this feature with some older programs but I never figured it would give Excel problems.   Now the question is how to fix it and/or prevent it from happening.    If I create a completely new document it does not have the same problem which is good.

If I figure out how to truely "fix" the document I will  post my findings here.  
0
 

Author Comment

by:rjpaw
ID: 34947002
See above comment
0
 

Author Closing Comment

by:rjpaw
ID: 34986560
I figured out the answer on my own.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

758 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

16 Experts available now in Live!

Get 1:1 Help Now