Excel 2010 Row numbers disappearing
-
2010년 8월 18일 수요일 오후 5:44Question: Bit of an odd one here.
Running Excel 2010 on a WinXP Sp3 box. Issue is only affecting one user and one of his spreadsheets. Sporatically, the actual numbers within the row identifier boxes vanishes, along with the data in the affected rows. The rows are still there, and the rows above and below are still numbered in the same sequencial order as if the affected rows were still numbered. If we do not notice this before saving spreadsheet, data is lost. If we unhide all cells, the numbers come back, as does the data. The odd thing is, as I said, the rows are NOT actually hidden, only the row identifier numbers and the data are gone.
Please help! Critical order tracking sheet.
모든 응답
-
2010년 8월 19일 목요일 오후 10:13
I wonder if this is caused by a screen refresh being interrupted and not finishing?
If you minimise and then restore Excel do the rows re-draw correctly?
If you scroll down so that the affected rows go off the top of the window and then scroll back up do the rows re-draw?If you open Excel in safe mode, by holding down the control key while opening Excel, does the problem still occur?
Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk- 답변으로 표시됨 Jennifer ZhanModerator 2010년 8월 24일 화요일 오전 2:01
- 답변으로 표시 취소됨 T. Mc 2010년 8월 24일 화요일 오후 12:17
-
2010년 8월 24일 화요일 오후 12:19
I wonder if this is caused by a screen refresh being interrupted and not finishing?
If you minimise and then restore Excel do the rows re-draw correctly?
If you scroll down so that the affected rows go off the top of the window and then scroll back up do the rows re-draw?If you open Excel in safe mode, by holding down the control key while opening Excel, does the problem still occur?
Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk
Minimizing/restoring does not resolve. Nor does scrolling off the screen. Oddly, what we found was that if we 'unfroze' rows, the information would return; even though nothing was actually frozen to begin with. As it is not only the row number identifiers, but the actual data within those rows, this is becoming a major annoyance. Rows above and below (even if not on screen) are unaffected. -
2010년 8월 24일 화요일 오후 2:04
OK. Sounds like it's not a screen refresh issue.
Did you try safe mode?
If you have the appropriate setup, can you try
- another user logged on to this user's computer running the program
- this user logged on to another computer running the programWhat resulted?
Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk- 답변으로 제안됨 Marshall Ringler 2011년 9월 14일 수요일 오후 1:50
-
2011년 1월 9일 일요일 오후 7:20
This happens to me also when I delete rows above. I have found that groupgs of three or four blank row numbers appear in a number of places. Also, some single rows with missing row numbers also appear.
This is flat out inexcusable!!! What is going on and what is being done to correct this problem?
Please email me any findings/suggestions at gstein@hotmail.com
Regards,
George
-
2011년 6월 24일 금요일 오후 2:16I am having the same problem...this is getting very annoying
-
2011년 7월 8일 금요일 오전 12:04
(same problem) - I opened Excel one time in safe mode as suggested by Bill Manville. That appears to have fixed the problem!
Thanks
-
2012년 2월 15일 수요일 오후 10:47
I get the same problem as well.
If you highlight the cell you can see the contents in the formula bar.
Pressing the Bold button will make the contents visible from within the cell again but this is not a permanent fix
-
2012년 2월 21일 화요일 오후 5:08
I have blank rows with no row numbers
Am looking at a spreadsheet with no row numbers 62, 63 and 73! And nothing in those rows
Am running a few months old branded PC with Windows 7 and Office 2010
And my PC (with 4GB RAM) will often not allow me to open more than one spreadsheet at a time - even when every other program is closed down
In recent weeks I have come round to the idea that Microsoft have lost the plot - can't they even produce a simple spreadsheet that works properly?
Apple are taking even the corporate world by storm with iPads. Will certainly be investigating a Mac when I get my next home desktop or laptop (can't believe I'm saying this) - I spend endless time dealing with Windows computers that freeze or respond very slowly. Why can they not produce a rock solid operating system and office suite that is fast and reliable?
And tried verifying my Windows Live ID - error message saying that the site was experiencing technical difficulties ...
-
2012년 3월 23일 금요일 오후 5:41I just had the same issue! I actually found that if i highlighted the row above through the row below and right clicked "Unhide" the data showed back up. So strange as it was not "hidden" just like you said. Interesting.
-
2012년 4월 1일 일요일 오전 12:33
I am having the same issue. The issue does not go away if you close and reopen the file.
I am running Excel 2010 64 bit (14.0.6112.5000) on a Window 7 Professional.
Before I read this post, I was making a copy of the worksheet and deleted the "old" sheet.
This "fixes" the issue temporarily, but it comes back. I will try the suggestions above.
However, I think we need a permanent solution AND I am concerned this issue will damage the file or the data.
-
2012년 4월 2일 월요일 오후 8:04
I am having the same problem. In my case, if the row number is missing, so is the first entry in that row, even though I know that entry is still there if I click on it. To make both the row number and the first entry re-appear, I increase the row width and then decrease it back to its original width. I thought the problem was solved, but now I have noticed that when I opened the same spreadsheet at a future date, other rows (and entries) disappeared.
I too need a permanent solution.
with thanks
John
-
2012년 4월 2일 월요일 오후 8:20
Let me add that the file I was having an issue with was an .xls.
So running an xls file type in 64 bit xlsx Excel may be part of the issue.
I have since saved the file as .xlsx. I will let you know if I have any issues.
If you guys that are having issues would:
1. note the Excel file extension (.xls, .xlsx, .xlsb, etc) and
2. what version of Excel (14, 64 bit)Maybe it has something to do with using 32 bit vs 64 bit or xls vs xlsx.
Let's start narrowing it down. Thanks.
-
2012년 6월 1일 금요일 오후 6:16
Hello All,
I am having the same problem. I think it happens when your data is "bottom aligned" and the row is only showing the middle or top part of the cell because some cells in the row are "wrapped text" or there is a cell later on in the row with a large font, or any reason that might cause the row to show only part of the contents if you manually adjust the size of the row so that it cannot display all the contents of the cell. I just increased the size of my row until I could see text and then realized it was bottom aligned. I changed it to center aligned and that solved the problem.
Hope this helps,
Christiana- 편집됨 Cmarsden ERG 2012년 6월 1일 금요일 오후 6:17
-
2012년 6월 8일 금요일 오전 8:18
Using Windows 7 Professional ver 6.1 (Build 7601 : Service Pack 1) and Excel version 14.0.6112.5000 (32 bit)
A large spreadsheet some 8MB and formatted as an xls file.
I experienced a similar problem with some row numbers and data missing together with some rows being expanded to a height of 550 pixels.
Highlighting the whole row and automatically resetting the height (double clicking bottom edge ) sometimes resets the height, row numbers and data.
Strangely highlighting the row and clicking the bold button also resets the the height, row numbers and data.
Unfortunately these remedy’s do not persist after saving the file and reopening it.
If I resave the "corrupted" xls version as a Macro-Enabled Worksheet .xlsm file all of the issues above disappear.
I hope this helps some one
-
2012년 6월 15일 금요일 오전 1:31
I have same problem. Only .xls, saving to .xlam fixes, but saving back to .xls corrupts.
Strangely, logging on as a different user on same machine can read the file OK.
Scary for those of us that rely on Excel.
Anthony
Anthony
-
2012년 8월 8일 수요일 오후 2:46 Hey, I had a similar problem, I just saved my file as .xlsm, then started excel in safe mode, then selected the range of rows I was missing, I was missing 52-54, so selected both 51 and 55 and then clicked unhide, and it worked, I was also able to save it back to an .xlsx and open it up not safe mode...danger mode. Hope this works for you peoples
- 답변으로 제안됨 fsdsffsd 2012년 8월 8일 수요일 오후 2:46
-
2012년 8월 8일 수요일 오후 5:08
check this link this may help you out
http://www.excelforum.com/excel-general/719597-excel-2007-missing-row-numbers-and-data-in-worksheet.html
-
2012년 8월 16일 목요일 오전 11:59
I know this is an old thread, but still may be relevant and helpful to others. I was missing rows 1 through 3. Selecting row 4 and selecting up with the arrow keys revealed information was in rows 1 through 3 but I could not select them. Using the Control + A I could select the whole sheet, then Control + 9 to hide all, then Control + Shift + ( to un-hide all and the rows reappeared. This was done on Windows 7 Pro, Office 10. Hope this helps someone.
Please note that the top left corner button that selects all does not work. You must select all with the Control function.
-
2012년 8월 23일 목요일 오전 3:59I had one user with this issue. Ended up deleting the whole Excel registry key folder in HKCU (14.0 for 2010). It got re-built automatically the next time open Excel. No issues since then. HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel
-
2012년 8월 27일 월요일 오후 7:42I had that issue with Excel 2010 64bit, and I noticed that the document was opening in compatibility mode, so I converted the document and the issue was solved. For now.
-
2012년 11월 4일 일요일 오후 5:36I had the same problem. I finally realized I was opening an xls file by just double clicking directly on the Excel file before I even had Excel open, and letting Excel come up that way. When I opened Excel 2010 first, then opened the file from Excel, everything was ok.
.png)
