ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data list collapses on refresh (https://www.excelbanter.com/excel-discussion-misc-queries/192709-data-list-collapses-refresh.html)

Jeff Metcalf

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.


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com