If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Status 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? |
#2
|
|||
|
|||
Status bar msg is gone
Check out Debra Dalgleish's site for info on this.
http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 14:19:23 -0500, "Kent McPherson" wrote: 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? |
#3
|
|||
|
|||
Status bar msg is gone
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. "Gord Dibben" gorddibbATshawDOTca wrote in message ... Check out Debra Dalgleish's site for info on this. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 14:19:23 -0500, "Kent McPherson" wrote: 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? |
#4
|
|||
|
|||
Status bar msg is gone
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. "Kent McPherson" wrote in message . .. 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. "Gord Dibben" gorddibbATshawDOTca wrote in message ... Check out Debra Dalgleish's site for info on this. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 14:19:23 -0500, "Kent McPherson" wrote: 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? |
#5
|
|||
|
|||
Status bar msg is gone
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 On Fri, 9 Feb 2007 07:37:08 -0500, "Kent McPherson" wrote: 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. "Gord Dibben" gorddibbATshawDOTca wrote in message .. . Check out Debra Dalgleish's site for info on this. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 14:19:23 -0500, "Kent McPherson" wrote: 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? |
#6
|
|||
|
|||
Status bar msg is gone
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! "Gord Dibben" gorddibbATshawDOTca wrote in message ... 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 On Fri, 9 Feb 2007 07:37:08 -0500, "Kent McPherson" wrote: 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. "Gord Dibben" gorddibbATshawDOTca wrote in message . .. Check out Debra Dalgleish's site for info on this. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 8 Feb 2007 14:19:23 -0500, "Kent McPherson" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|