Solved

Excel 2007 issue

Posted on 2013-06-11
3
182 Views
Last Modified: 2013-06-26
I have a user using windows XP and excel 2007.  When this user tries to filter something in excel the boxes aren't coming up so she can check the dates... See attached. The user to this point has been rebooting - but to me that's  not a solution.  Any help would be appreciated.
excelerror.png
0
Comment
Question by:WellingtonIS
3 Comments
 
LVL 12

Accepted Solution

by:
Seaton007 earned 500 total points
ID: 39238316
0
 
LVL 6

Expert Comment

by:Tonypeswani
ID: 39267632
The data you are trying to filter might contain merged cell.Split the merged cells in your workbook and then check.

Thank you.
0
 

Author Closing Comment

by:WellingtonIS
ID: 39278578
Sorry it took so long to get to this.  But that article worked.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
cloning computer 13 67
Formula 6 47
Merging-Splitting-Multiple-Rows 33 45
Error in formula not increasing value 2 15
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now