Big_Belly_Bob
New Member
- Joined
- Feb 9, 2006
- Messages
- 27
Ok has anyone come across this problem before?
You're using an autofilter on a large amount of data in excel say 4000 lines or something, and you pick out just half a dozen lines that have something you don't want in i.e. lines with 0 or with text that doesn't match what's on the other lines. Then you delete the lines.
Normaly I'd exspect this to just delete the few rows that you have filtered on leaving the rest of the 4000 lines so that when you unfilter you are left with just the data that you want. However very occaisional I find that it deletes all the lines in between as well so that when I unfilter I'm left with only a couple of hunderd lines.
For me it doesn't happen that often but I have a friend who says it happens to here all the time and she's actualy now paranoid about it. I can't see that she's doing anything different to me and I can't see why it occaisionaly does it to me. I've seen this in Excell 2007 and 2003 has anyone else seen it? and also if you have do you know what's causing it? is it user error? or something to do with the spreadsheet?
You're using an autofilter on a large amount of data in excel say 4000 lines or something, and you pick out just half a dozen lines that have something you don't want in i.e. lines with 0 or with text that doesn't match what's on the other lines. Then you delete the lines.
Normaly I'd exspect this to just delete the few rows that you have filtered on leaving the rest of the 4000 lines so that when you unfilter you are left with just the data that you want. However very occaisional I find that it deletes all the lines in between as well so that when I unfilter I'm left with only a couple of hunderd lines.
For me it doesn't happen that often but I have a friend who says it happens to here all the time and she's actualy now paranoid about it. I can't see that she's doing anything different to me and I can't see why it occaisionaly does it to me. I've seen this in Excell 2007 and 2003 has anyone else seen it? and also if you have do you know what's causing it? is it user error? or something to do with the spreadsheet?