View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Metcalf Jeff Metcalf is offline
external usenet poster
 
Posts: 9
Default Data list collapses on refresh

I have a worksheet that pulls a list of data from SQL Server using ODBC/MS
Query.
The columns are sortable and selectable.

Every time I refresh, the entire data area collapses, and I have to unhide
the rows, and the Filter Drop down just shows Select All, instead of Select
All and the items to select.
It happens if I just use a text filter also.

This didn't use to happen.

Anyone have a why or how to fix it?

Thanks in advance.