Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Windows update affects XL97 AutoFilter
Hi All.........
I wrote a program a couple of years ago that has worked fine ever since, till today. Today MIS blessed all of us with an unannounced "Windows Upgrade", (WinXP) that took over our computers and demanded a re-boot or would not function any further until we did. Once taking the "upgrade", it took 2-3 re-boots to get back to normal. Then, when re-opening the Excel Program, the AutoFilter function started acting up. The database is 16000 rows and about 25 columns. The procedure is.....First filter on a dropdown from the column C arrow, then on one from the column G arrow, and then delete one row.....then try to filter on a different selection from column G and Excel freezes up. Does not work from there on. Before today, this procedure worked fine. Doing Ctrl-Alt-Delete and trying to "EndTask", shows two instances of Excel in the window......non-responding, even tho we only had one running. This all in XL97, the same on two different computers.......when I tired the same thing with the same file in XL2002 from the same network directory, all worked fine. The problem appears to have affected XL97 but not XL2002, and apparently was not related to the file as such......have not tired with XL2000 yet. Anybody run across anything like this yet? If so, any fixes........... Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
How do I update filters when using Autofilter? | Excel Worksheet Functions | |||
I had a workbook open (not saved) and Windows Update Restarted!!! | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel |