I have a client using Office 2010 on a Citrix server. They are using Windows XP Pro SP3 for the desktop and the server is running Windows Server 2003 R2 STD.

I have two users working in a spreadsheet in Excel 2010. The spreadsheet opens fine and they can perform their updates by either adding manually or doing a cut and paste. The problem comes up when all of the sudden a number of rows in the spreadsheet change height for not reason. The spreadheet has the row height set to 14.5 but for some reason the rows that change height sent the height to 405.9. Usually all the user has to do is go back and reset the row height on these cells and save before they can go back to making changes.

It's more annoying then anything else so if someone could provide any solutions, it would be greatly apppreciated.

thanks, Joe Trainor

Hi,

When you paste in Excel 2010, you can see the paste option which is next to the text you paste.

And click the drop-down arrow of this option and choose "Keep Source Column Width".

Or you can right click the cell and choose "Paste Special" to select "Keep Source Column Width".

Hope that helps.

Jennifer,

The problem is not with the width but with the height of entire rows changing, and the rows that change are not even being accessed at the

time, they could be 10 or more rows down that change height.

Hi,

"For no reason"?  Does this mean that the user is doing nothing when this happens?  And by nothing I mean they don't even have their hands on the mouse or keyboard.  If the user is doing something what is it?  Are they copying and pasting, formatting a cell or saving or something else?

Shane,

I have sat with an open remote session watching her work. The user can work on the spreadsheet entering data. minimize Excel and come back to it after a few minutes and 3-4 rows will have changed height. The rows that change height are usually not the same place where the user may have been entering or pasting data, usually the change happens a few rows down.

This is affecting only two users that work on the same worksheet and as far as i know no one else in the organization is affected.

Joe.

This may be a consequence of wrapping. If for example some distant (thin width) column contains

w
ra
p
p
in
g

then it will jack up the row height when you do something completely unrelated, 50 columns away from that cell, but on the same row.

A strong clue that this is the culprit is if you mark an entire row and hit the delete key (relax, you'll 'undo' this immediately) and the row instantly returns to default height.

I too am having the problem with Excel 2010 where the row height of just some rows randomly resets to 409.5.  Just this week started using 2010 and this is driving me nuts because it is showing up on nearly every file that I open (about 50 files daily).  Repairing and saving does not fix the problem.  AARGH!

I believe I am having the same problem, although I haven't checked to see if it is resetting to size 409.5.  To correct you have to manually reset those row heights - I have tried several times to auto-set the row heights but then it hides the rows / sets their height to zero.  I thought this was a corrupt file, but decided to google the problem before migrating everything to a new file - that's how I stumbled across this...I have also just remembered I migrated this particular file to a new file to try and fix this problem in the past, and it did nothing.

All I can say is that I work in 2010 and 2007 and this doesn't happen to any other files, just this one file in particular (although nothing special about it).  I work in both the 64bit and 32 bit version of Excel and have noticed it more in the 64bit, although that's anecdotal, I haven't specifically been trying to remember which version was causing more problems.

Come on MS - Any feedback on this?  I'm glad I'm not the only one with the problem, some feedback would be useful.

Regards

Hello,

Please try the following to resolve the issue:
1. Boot Excel 2010
2. Open [Excel Options] dialog. ([File]-[Options])
3. Select [Advanced] tab, turn on [Cut, copy and sort inserted objects with their parent cells] option. (In [Cut, copy and paste] section)

*This will not resize rows that are currently set to 409.5 but I would like to know if this keeps rows from doing this in the future.

*Please vote as helpful if this is resolving your issue.

Best Regards,
Chad

Chad - 

That change seems to have solved the Fat Rows issue.

Thanks

Hi Chad,

Sorry for being slow to respond to this - that option is already set in the file.  Will try deactivating it and then reactivating it, but not sure it's going to achieve what you wanted.

Regards,

Digittt

I am also experiencing a problem where the row height of several rows (also below the area that I am working on) has the row height changing by itself to 409.5.  I am using Excel 2010 on one computer and Excel 2007 on another computer.  I'm using Sugarsync to keep the data on both machines synchronized.  I noticed that I can't just fix the problem by resetting the row height back to 12.75.  Sometimes I have to delete the rows.

I also figured out that the problem goes away when I turn off Sugarsync or so it seems so far.  Anyone else using any kind of synchronization software?

Chad,

Ok, I just confirmed that my Excel options were set as you asked.  It was already set that way.  I also wanted to let you know that even after manually resetting the row heights of the affected cells back to their proper height (11.25 in my case), some of the cells lost their numbering on the right side.  For example, I could see the cell numbering for 3xx and then the next 10 or so cells had no numbering and then the numbering resumed.  I also discovered that I get the row height formatting automatically changing to 409.5 even when I disable the SUgarsynch program so now I'm thinking that it is unrelated.

When I save the fiel and reopen it, the cell numbering is back to normal.  I hope this information helps since this problem is driving me crazy.

Hi Mad.Cow...

FYI...  I am experiencing the same issue at one of my clients as you are.  They have the problem with Excel 2010, and it occurs on both Windows XP Pro & Windows 7 Pro workstations.

So far, I am not able to determine how it occurs.  I have tried the recommended steps above too without luck.  And it is strange that it appears to take random rows & max them out for no rhyme or reason.

Well, if I find the solution, I'll post it, but in the mean time, maybe the more people that post that they are having the issue, the sooner Microsoft can get a solution for us.

Hi. 

I have the same problem where randomly two or three of the row heights have changed to max when I scroll down. I am using Excel 2010 and Win 7.  With Excel 2007 and Vista there was no problem with the same files.  Also occurring is same problem as mentioned by 'madcow' where on some rows (not necessarily the height changed ones) the numbering disappears as well as all the data along that row! 

Another issue is that only in Excel, randomly some print jobs disappear - says printing but nothing happens and to get printer to print I have to restart the print spooler.  Double sided printing in Excel also does not work.  Lexmark advise it must be a software issue with Win7/Excel!

All of these problems are random!  I have reinstalled Win 7, repaired MS Office 2010 in case it needed it, downloaded all available updates, as well as uninstalled and reinstalled the printer!!!  Nothing seems to work!  Hope there is a solution soon!

Tks & brgds.

Chad,

I have been having the same problem with Excel 2010.  We use spreadsheets for our estimating and I recently upgraded to 2010 from 2003.  This problem did not occur with 2003 but is now randomly occurring.  I have not been able to identify a particular activity that is triggering it.  I may make several entries in different parts of the sheet and then scroll down to another section and find this on anywhere from 1 row to a dozen rows.  I do know this only happens below where I am working.  It has never occurred above where I am working.  I do not use any images and all I am doing is entering cost and labor hours on the sheet.  I may cut and paste some rows to different locations in the spreadsheet.  I checked your suggestion above and (Cut, copy and sort...) is already turned on.  any other suggestions?

I've got the same issue.

Windows 2003 R2 UK server 32-bit
Office 2010 Plus NL

Advanced Cut, Copy, Sort option allready turned on.

I'm getting the same issue as well:

Windows 7 Pro; Excel 2010 (Home & Business)

Seems to occur when working on spreadsheets that have been created or modified in Excel 2003.  No rhyme or reason to which rows are affected, but I'm seeing both the 409 height rows and the normal spaced (but unnumbered and blank) ones.  Going to the file screen and converting the file to .xlsx instead of viewing it in compatibility mode fixes everything.  But you have to do that with each file and it creates a copy instead of just fixing the file you're working on, so it's a really clumsy fix to have to do each time you get a file.

Would love to see Microsoft fix this one since it's made an otherwise solid version of Excel very frustrating to work with.

Thanks, and please post if anyone's found a solution.

I'M HAVING THE SAME "SYMPTOM"!!!!

What's unique about my issue:

#1) It manifested after about 2 months of using MS OFFICE 2010. all of a sudden prominent issue! 

-working mostly with excel 2003 docs

#2) It only happens with documents containing data in large number of rows. -the rows beyond (below) the visible screen (scroll down) all get this HEIGHTENED issue.

-i have to maximize screen view and go into and auto-resize 100s of rows to remedy

-often when i do it makes the top, uncorrupted rows all of a sudden hidden and i have to unhide

#3) --separate symptom -- lately i open documents and the text in certain cells are invisible, and i have to autosize the row to make visible?!cell numbers are invisible too.

IM SO TIRED OF THIS ****!!! :P James

Hi there!

I am having the same problem!  Really frustrating to change the row hights every time!  I have also checked the Options Tab.  The [Cut, copy and sort inserted objects with their parent cells] was already ticked.

I hope we get an answer soon!

Hello -

Same problem here as well.  For me it happens after a save and close.  I will have gone through the doc, making sure all rows are set to 11.25 height.  Then I save and close the document.  The next morning, when I re-open it, and simply scroll down (taking NO other actions), there are rows again with height set to over 400.  I am on a trial of 2010 (needed it to test out OneNote, which I like) but I will not actually purchase 2010 until this issue is recognized and resolved by Microsoft.  It's a productivity KILLER.

To Chad - as with other users reporting the same problem, the Cut/Copy/Paste Advanced Option is aiready set to "on."  So no help there...

- Pat

We also have an issue with it resizing the rows while deleting rows but upon testing it appears that it will resize the rows of an Excel document saved to 2003 format in Excel 2010 but not Excel 2007.  It appears it has something to due with compatiblity mode.  When we saved the document to the newer format we no longer had an issues with the reiszing.  Can anyone else confirm this?

Thanks.

Nevermind the compatiblity as a problem.  I went back and tested the problem on the original computer it still occured.  However, I did find a workaround.  If we do a print preview before working with the documents, they will not have the row resizing issue.  Please test this and post your responses.

Thanks.

Have you tried print previewing when opening the document to see if it still has the issue?

The problem is created by the CELL ALIGNMENT functionality - The strangely heightened rows in my 2003 to 2010 spreadsheet all had varying alignments in different cells across the same row, generally tops and bottoms. When I make them all the same the row pops back to standard height. Cell wrapping is not the problem but can do a similar thing if you are not paying attention with column widths, sooo....

1. Select the entire table or work-area or range i.e. select a1, press f8, press control/end. This will select the entire space you are currently working in. (Alternately you could select the entire sheet by clicking the little square at the corner of A and 1 but this will effect any header rows that you might want to keep specifically alligned)

2. On the Home Toolbar choose bottom alignment, then top allignment, then bottom allignment again....viola, all strange rows should recover their standard height.

Save, close then open to check all is hunky dory....

Chad,

I am waiting for Microsoft to issue a patch for office which I hope will fix this problem.  I have found a workaround that works for me for the problem with the random row height changing to the maximum on some rows on worksheets while you are working on them.  Before when the rows appeared, I was going through the rows one by one and changing them back to proper height.  What I do now is save the workbook or worksheet, close it and reopen it.  The affected cells have been returned to normal on all 4 worksheets I have tried this on.  I hope this helps.

I am waiting for Microsoft to issue a patch for office which I hope will fix this problem.  I have found a workaround that works for me for the problem with the random row height changing to the maximum on some rows on worksheets while you are working on them.  Before when the rows appeared, I was going through the rows one by one and changing them back to proper height.  What I do now is save the workbook or worksheet, close it and reopen it.  The affected cells have been returned to normal on all 4 worksheets I have tried this on.  I hope this

hi,

I also had the same issue, ... if in a big excel document rows where deleted, some of the rows that were off screen got a height of 405.9

After investigation I noticed that the vertical allignment of the cells was set on "bottom" (sorry if the term Bottom is not correct I have a dutch office 2010 and in dutch it is called: onder uitlijnen) this is the picture:

To fix it: just press control-A and change it to the default vertical alignment (upper?) or in dutch: boven uitlijnen.

This fixed the issue for our users.

I hope this helps ...

Sorry new to this technet forum, this is what I posted to the original message:

hi,

I also had the same issue, ... if in a big excel document rows where deleted, some of the rows that were off screen got a height of 405.9

After investigation I noticed that the vertical allignment of the cells was set on "bottom" (sorry if the term Bottom is not correct I have a dutch office 2010 and in dutch it is called: onder uitlijnen) this is the picture:

To fix it: just press control-A and change it to the default vertical alignment (upper?) or in dutch: boven uitlijnen.

This fixed the issue for our users.

I hope this helps ...

Good Worked

Chad,

Your solution corrected this problem.

Thank you!

Hi All. I've also had this problem and though I can't give a solution I do have a helpful workaround.

This issue has cropped-up repeatedly for me when I've had two workbooks open and I've been working down and deleting selected rows in one before copying and pasting across to the other. I've found that if I start at the bottom of the source workbook and delete the rows (either singly or in blocks) I avoid the problem without the need to change any formatting.

worked great.  Select all, change alignment to top.  Thanks Bruce!

Hello,

Please try the following to resolve the issue:
1. Boot Excel 2010
2. Open [Excel Options] dialog. ([File]-[Options])
3. Select [Advanced] tab, turn on [Cut, copy and sort inserted objects with their parent cells] option. (In [Cut, copy and paste] section)

*This will not resize rows that are currently set to 409.5 but I would like to know if this keeps rows from doing this in the future.

*Please vote as helpful if this is resolving your issue.

Best Regards,
Chad

It has to do whit Excels last used Cell \ range, it expands per session, and only gets reset ones you restart Excel where it will search for last used cell on sheet.

If you use vba or manualy push Down cells by useing insert cells pushdown (regardless if it moves anything Down, the scrollbar will be expanded).

(Excel doesnt care that theres nothing in those cells, you can do this on a clean sheet whit nothing on it, just by inserting rows....)

The fix is simply invokeing the check for last used cell or range by Excel.

Just boot up the VBA editor and type

Option Explicit ' This is usualy here by default
Sub Marine() ' Sub Machinegun() Can work too, but sub marine is my favorite :o

   ActiveSheet.UsedRange 'This makes Excel check activesheets current used range and resets scrollbar.
	'Also noteably Excel seems to speed up whenever it has less used active rows\columns
	'regardless if anything is in use or not, im guessing it puts all "active" rows
	' in auto calculation mode, hence slower~

end sub