Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
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
Create refresh button in worksheet to refresh Pivot Table Data Ron Excel Worksheet Functions 1 October 13th 07 01:20 AM
Excel data filter collapses rows even after I select show all!?!?!? [email protected] Excel Discussion (Misc queries) 4 January 9th 07 12:42 PM
name of icon that collapses dialog box Sally Excel Discussion (Misc queries) 1 March 26th 06 04:26 PM
Refresh existing data when changed in data validation list problem girl New Users to Excel 1 September 28th 05 10:19 PM
Date format collapses diagram Richard H Excel Discussion (Misc queries) 3 December 14th 04 11:08 PM


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

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

About Us

"It's about Microsoft Excel"