 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / February 2007Status bar msg is gone
I have a spreadsheet where I enable auto filtering. When I select a particular filter category, normally in the status bar, it says xx of yy records selected. But this is gone in my worksheet. If I copy the entire data set and paste it into a new worksheet in the same workbook and do the filter, it works! The status bar is turned on. Any ideas why it doesn't show up in this particular worksheet? Check out Debra Dalgleish's site for info on this. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP >I have a spreadsheet where I enable auto filtering. When I select a >particular filter category, normally in the status bar, it says xx of yy >records selected. But this is gone in my worksheet. If I copy the entire >data set and paste it into a new worksheet in the same workbook and do the >filter, it works! The status bar is turned on. Any ideas why it doesn't >show up in this particular worksheet? Thanks, good ideas and discussion there. My problem isn't exactly what is described. My problem is when the filter is applied the status bar still shows "Ready". Something is whacky on the data on this sheet. Can't figure out what it is. > Check out Debra Dalgleish's site for info on this. > [quoted text clipped - 12 lines] >>filter, it works! The status bar is turned on. Any ideas why it doesn't >>show up in this particular worksheet? Actually, here is another data point. The work-around that is described on the Microsoft site, i.e. turn off automatic formula calculations, works for my situation too. The funny thing is I have no formulas on this worksheet at all. > Thanks, good ideas and discussion there. My problem isn't exactly what is > described. My problem is when the filter is applied the status bar still [quoted text clipped - 18 lines] >>>filter, it works! The status bar is turned on. Any ideas why it doesn't >>>show up in this particular worksheet? Kent I also am curious. If you wish, you could email the workbook to me. But, if copying the data to a new sheet solves the problem why not do that and delete the original? Doesn't give you a reason for the problem however and that's what you are looking for. Gord >Thanks, good ideas and discussion there. My problem isn't exactly what is >described. My problem is when the filter is applied the status bar still [quoted text clipped - 17 lines] >>>filter, it works! The status bar is turned on. Any ideas why it doesn't >>>show up in this particular worksheet? I found the reason. It was because of named ranges I had defined on this worksheet. The pointers to the MS support website were very helpful! > Kent > [quoted text clipped - 39 lines] >>>>doesn't >>>>show up in this particular worksheet? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.