Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excell 2003 losing rows

12 Mar 2011   #1
PoBear

Windows 7
 
 
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 System SpecsSystem Spec
.
12 Mar 2011   #2
PoBear

Windows 7
 
 

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 System SpecsSystem Spec
12 Mar 2011   #3
PoBear

Windows 7
 
 

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 System SpecsSystem Spec
.

13 Mar 2011   #4
Irene

Windows 7 Home Premium 64bit
 
 

Quote   Quote: Originally Posted by PoBear View Post
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 System SpecsSystem Spec
Reply

 Excell 2003 losing rows




Thread Tools




Similar help and support threads
Thread Forum
WMC:- How do I increase # of rows in the EPG?
The standard 7-row WMC EPG on my Windows 7 64-bit system wastes a lot of screen space I want to increase number of rows to 9, 10 or 11 I've seen instructions for doing this on a couple of sites, but the reader comments indicate a high failure rate Can anyone point me to reliable instructions...
Media Center
install excell 2003 alongside office 2010
hi i have installed office 2010 and in excel i need to save files in wk4 file formate .. and excel 2010 is lacking this feature. whereas excell 2003 has this feature. can i install excell 2003 alongside office 2010 ? i need word/outlook/access/onenote/ in 2010 format . whereas excel in 2003....
Microsoft Office
Blank page in excell 2010
Hi guys can i ask a question please I am using Microsoft office 2010 and for some reason now when i open an Excel spreadsheet and enter data, then when i close Excel, behind the one i was using is another blank Excel worksheet its just blank with no cells or anthing like that just a blank page. ...
Microsoft Office
Re: EXCEL- resorting rows so they each relate to original rows
Hi, I couldn't find an answer in the Forums for this in the past half hour of looking through them- there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7...
Microsoft Office
Excell opens in task bar
I am running Microsoft XP Prof 2002 SP3 with Microsoft office 2007 everything works like it should accept for Excel when I open it it appears to open and directly goes to the minimize position in task bar and never really opens up I have checked for updates none I am up to date I tried repair...
Microsoft Office


Our Sites

Site Links

About Us

Find 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 12:38.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App