Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting and the Summary Bar
When I'm filter a list of data, I used to see a "1 of 10" (or whatever) in
the summary bar. I no longer see it...any ideas how I can turn it on? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting and the Summary Bar
I found the answer...it is as follows:
This problem may occur when the following conditions are true: You have 51 or more formulas in a list. -and- You filter the list in-place (that is, you click AutoFilter on the Data menu, and then select a value from the AutoFilter list; or you click Advanced Filter on the Data menu, click Filter the list, in-place, and then select a value from the filter list). -and- Each formula contains at least one cell reference. -and- Excel makes a change to the status bar to indicate the calculation of formulas before the filter process is completed. Back to the top WORKAROUNDTo temporarily work around this problem, prevent the formulas from calculating w...To temporarily work around this problem, prevent the formulas from calculating when you run a filter. To do this, follow these steps: On the Tools menu, click Options. In the Options dialog box, click the Calculation tab. On the Calculation tab, click Manual under Calculation. Filter the list to see the filter results in the status bar. To restore calculation, on the Tools menu, click Options. Click the Calculation tab, and then click Automatic under Calculation. "Jamie" wrote: When I'm filter a list of data, I used to see a "1 of 10" (or whatever) in the summary bar. I no longer see it...any ideas how I can turn it on? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting and the Summary Bar
Debra Dalgleish explains it and offers a workaround:
http://contextures.com/xlautofilter02.html#Count Jamie wrote: When I'm filter a list of data, I used to see a "1 of 10" (or whatever) in the summary bar. I no longer see it...any ideas how I can turn it on? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) |