Monday, September 26, 2016

How to Fix - Date Filters in Excel 2007 not working?

Date Filters in Excel 2007 not working

Column E has manually input dates.
Column F has dates computed using a formula.
When Autofilter is applied, Column E shows the Date Filters option, while the Filter in Column F shows Text Filters only.
How can I get Date Filters in Column F.
Incidentally, both Column E and F are formatted as Dates.
Thanks in advance for the help.

Keys to the Problem Date Filters in Excel 2007 not working

Download SmartPCFixer for Free Now

Raj sent me the file.
It seems it gives Text Filters when there are more text values ("") than date values in the list.
I deleted rows from the unused area until dates had a majority and then Date Filters was given instead.
3 solutions suggest themselves:
a) clear the additional rows.
  - on entering a date at the bottom of column E, the formulas in F should fill down automatically,
  (if not, set Office Button > Excel Options > Advanced > Editing options: extend data range formats and formulas)
b) turn the used rows into a Table
  - this should always extend the formulas when you add a date in a new row at the bottom of the table
c) change the formula to give 0 for missing dates, and apply the custom format dd-mmm-yy;;  (note the 2 semi-colons) to the formula cells.

Bill Manville.
Excel MVP, Oxford, England.

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Another Safe way to Fix the Problem: Date Filters in Excel 2007 not working:

How to Fix Date Filters in Excel 2007 not working with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will perform a scan for your system. The errors will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed

Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 -,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v. driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error

No comments:

Post a Comment