Excel 2003 on Vista: Some rows disappear in worksheets

  • Thread starter Thread starter Ritg
  • Start date Start date
R

Ritg

My laptop runs Vista. And I use MS Office Excel 2003 (11.8231.8221) SP3, part
of MS Office Professional Edition 2003.

I have the latest copy of Norton AntiVirus (Norton 360). There are no known
viruses or spyware on my laptop.

I am seeing the following problem in one of my worksheets:
- The worksheet has 187 rows and the last column is 'T'.
- When I open the document or when I am editing the worksheet, I find that
some rows disappear suddenly.
- The rows that disappear are not always the same ones. (they randomly
disappear)
- These rows are not part of any group. (none of the rows in the sheet are
grouped at all)
- When the rows disappear, the rows numbers indicate as if the rows have
been hidden (similar to performing a Format -> Row -> Hide) automatically.
- The rows become visible when the suspect row is selected and double
clicked upon on the row edge. However, Format -> Row -> Unhide does not solve
the problem.
- Upon recovering the missing/disappeared rows, closing excel and reopening
the document does not solve the problem. The same or some other unrelated
rows disappear again.
- One observation is that all these rows have their row-numbers in 'blue'
colour unlike the remaining (unused) rows which are numbered in 'black'. Not
sure if this is any indicator.

Please let me know how this problem can be solved.

Thanks.
 
Hi,

Well if the row numbers are turning blue there is an Auto Filter applied.
Since you are doing nothing when this happens it suggest that there are VBA
macros in to file.

Turn off the Auto Filter (or Advanced filter) by choosing Data, Filter, Show
All, or Data, Filter and unchecking Auto Filter.

You may also want to check for VBA code.
 
Back
Top