(Msg. 1) Posted: Tue Aug 19, 2008 3:44 am
Post subject: Filter Error Archived from groups: microsoft>public>excel>crashesgpfs (more info?)
Hi, I use Excel 2007 a lot using filters to narrow my looong lists and
applying different formulas to my different filterselections. Many times the
applied formula or formatting also is applied tothe the rows not included in
the filter. example.
A list of 10 recorsd/rows. My filter selection returns 5 records ( row
2,3,5,6,7)
I apply RED as color on the 5 lines visible. When removing the filter, all
rows between 2 and 7 are RED. Very SCARY, since I use this function to apply
different formulas ( read: conditions ) to differnet products I sell. So I
have lost a lot of money applying wrong sell prices to customers, this just
because the rows are inbetween some other filtered rows... Please HELP...
In Excel 2003 this was not a problem,,,,,
(Msg. 2) Posted: Sat Aug 23, 2008 12:24 pm
Post subject: RE: Filter Error [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You say 'Many' times that means you do something different sometimes which
leads to the problem.
I tested your scenario in 2007 and did not have any problem.
Try to list the steps you perform which lead to the problem.
"Frodo" wrote:
> Hi, I use Excel 2007 a lot using filters to narrow my looong lists and
> applying different formulas to my different filterselections. Many times the
> applied formula or formatting also is applied tothe the rows not included in
> the filter. example.
> A list of 10 recorsd/rows. My filter selection returns 5 records ( row
> 2,3,5,6,7)
> I apply RED as color on the 5 lines visible. When removing the filter, all
> rows between 2 and 7 are RED. Very SCARY, since I use this function to apply
> different formulas ( read: conditions ) to differnet products I sell. So I
> have lost a lot of money applying wrong sell prices to customers, this just
> because the rows are inbetween some other filtered rows... Please HELP...
> In Excel 2003 this was not a problem,,,,,
(Msg. 3) Posted: Tue Aug 26, 2008 10:44 am
Post subject: RE: Filter Error [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi:
I have a similar problem. I believe it's a bug in Excel 2007. When I use
"filter" in Excel 2007 and try to delete all the visible rows, sometimes, it
deletes all the rows between the first and the last visible rows but
sometimes it only deletes the visible rows. I guess we just have to be extra
careful when using the "filter" now since Excel 2007 apparently is not as
reliable as it's 2003 version until someone in Microsoft fixes it.
"Frodo" wrote:
> Hi, I use Excel 2007 a lot using filters to narrow my looong lists and
> applying different formulas to my different filterselections. Many times the
> applied formula or formatting also is applied tothe the rows not included in
> the filter. example.
> A list of 10 recorsd/rows. My filter selection returns 5 records ( row
> 2,3,5,6,7)
> I apply RED as color on the 5 lines visible. When removing the filter, all
> rows between 2 and 7 are RED. Very SCARY, since I use this function to apply
> different formulas ( read: conditions ) to differnet products I sell. So I
> have lost a lot of money applying wrong sell prices to customers, this just
> because the rows are inbetween some other filtered rows... Please HELP...
> In Excel 2003 this was not a problem,,,,,
(Msg. 4) Posted: Tue Aug 26, 2008 10:50 am
Post subject: RE: Filter Error [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
forgot to add, click "select visible cells" before you color those rows
should solve your problem, assuming there is no more bug.
"Frodo" wrote:
> Hi, I use Excel 2007 a lot using filters to narrow my looong lists and
> applying different formulas to my different filterselections. Many times the
> applied formula or formatting also is applied tothe the rows not included in
> the filter. example.
> A list of 10 recorsd/rows. My filter selection returns 5 records ( row
> 2,3,5,6,7)
> I apply RED as color on the 5 lines visible. When removing the filter, all
> rows between 2 and 7 are RED. Very SCARY, since I use this function to apply
> different formulas ( read: conditions ) to differnet products I sell. So I
> have lost a lot of money applying wrong sell prices to customers, this just
> because the rows are inbetween some other filtered rows... Please HELP...
> In Excel 2003 this was not a problem,,,,,
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office