Do you use AutoFilter or do you filter in a table in excel 2007


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
On Sep 27, 5:36 am, Moon wrote:
When I need to delete some filtered rows, In excel 2003, I will filter the
items that need to delete follow by highlight all rows then select delete
rows will do.
However in excel 2007, the same step will delete the whole content even
though the unfiltered rows.

Pls help!

I have encountered the same major annoying &*#$!#!! problem in Excel
2007.

- I work on more than 40,000 rows of data.
- I setup a criteria to filter the data.
- Filter is applied which hides the rows that didn't meet my
criteria.
- I perform computations on the remaining rows.
- I remove the filter or aka, "show all" records.
- !@#$!!. All records were affected by the computation. Rows that
weren't intended to be updated were updated.
- Same procedure, I did it over and over. What's worse is, It will
work on the 1st try and fail on the 2nd. It will fail on the 1st, it
will work on the 2nd. !@#$ Annoying.

- Same process, I tried on Office 2000, 2003. And it works fine, 100%.
It DOESN'T affect the filtered/Hidden records.

- This is probably another bug. An addition to the 850 * 77.1 bug that
was just recently discovered. FYI, try that 850 * 77.1 on a calculator
vs Excel 2007 and compare the result.