LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
How do I update filters when using Autofilter? SunGod_69 Excel Worksheet Functions 3 July 25th 06 06:53 AM
I had a workbook open (not saved) and Windows Update Restarted!!! WEEDSTER Excel Discussion (Misc queries) 4 February 17th 06 04:19 PM
options to update automatic links Werner Rohrmoser Excel Worksheet Functions 0 November 10th 05 12:58 PM
Prompt to update links Werner Rohrmoser Links and Linking in Excel 0 November 3rd 05 09:47 AM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"