Excel 2010 randomly adjusting row height after deleting rows

I'm having a problem with excel 2010 when I delete rows. Sounds like the same as what is happing in the thread linked below.


http://social.technet.microsoft.com/...f-5fbac0956add


For me, it only seems to happen when I delete entire rows. The weird thing is that I've been using 2010 for several months and this has not been an issue. Suddenly now it is. I'm not doing anything different that I am aware of. The only other weird thing I noticed recently is that some of the macros that I have that set page breaks automatically are not working properly. The page breaks are being set too far down, resulting in soft breaks a few rows before hard breaks and some pages with very little data.


I do have a dual installation of 2010 / 2003 but I never use 2003 anymore so I guess I could get rid of that. I did have some issues in the past after updates where I had to repair the 2010 installation so maybe I'll try that to see if it helps.

I was able to make things work by resetting the vertical alignments in all cells to bottom justify as noted in the links thread but that's kind of a pain and now I wonder if the row height issue and the new inability to accurately find page breaks might be related.

Any thoughts?

I found a not too complicated fix / workaround for this.


Select the rows that were improperly sizes, change text alignment format then immediately undo the text alignment. No change to the file but it fixes the row heights.