Excell 2003 losing rows


  1. Posts : 51
    Windows 7
       #1

    Excell 2003 losing rows


    I have a large 4000 x 25 Excell 2003 spreadsheet that keeps losing rows of data.

    I normally add 5-10 rows a day and over the last few weeks I have noticed that a couple of days data has disappeared every so often. The sheet is being closed cleanly and saved. Fortunately I have a daily backup so I have been able to go back. the data is there for two days after it was originally entered and then disappears.

    There has been no restore of the data and the rows have not been acidentally deleted.

    Anybody got any ideas.

    Thanks
      My Computer


  2. Posts : 51
    Windows 7
    Thread Starter
       #2

    OK - ignore the losing data, when I went to restore the missing rows I found that the section they were to go into had the row height set to zero!!! Problem is I didn't do this and i can't reset the row height using format, I am having to manually pull each row down.

    Any ideas about this and sorry for the intial bun stear?
      My Computer


  3. Posts : 51
    Windows 7
    Thread Starter
       #3

    OK - mea culpa. I had Autofilter enabled and somehow one of the columns had a specific value set rather than all. Still now idea how, but the data is all there so who cares.
      My Computer


  4. Posts : 3,009
    Windows 7 Home Premium 64bit
       #4

    PoBear said:
    OK - mea culpa. I had Autofilter enabled and somehow one of the columns had a specific value set rather than all. Still now idea how, but the data is all there so who cares.
    Thank you for explaining - might just help someone else experiencing the same issue.

    Well done for taking regular backups!
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 03:21.
Find Us