Drop Downs buttons & Comments are disabled in Excel 2007? [Anwsered]

Drop Downs buttons & Comments are disabled in Excel 2007?

Dear all,
I am using Excel 2007 and a couple of months back, i entered some important information using comments on every cell.
Also, i placed drop downs on some sheets.
Now, my problem is that i can not access those comments or drop downs.
When i click show all comments on Review button, it does not work but if i place my cursor on cell, it shows me my comments.
Similarly, drop down button is disabled that i used to select
the data from on almost every sheet.
Kindly help!
Warm regards
Dharmesh

Keys to the Problem Drop Downs buttons & Comments are disabled in Excel 2007?

Download Error Fixer for Free Now

Does this issue occur only with this specific Excel file or is it across all Excel files?
Verify what happens if you create new Excel spreadsheet with drop down and comments.
Open Excel > Click on Office button > Excel options > Advanced > Display > For cells with comments, show > which options is checked?
You may also check if Office 2007 service pack 2 is installed on the computer.

Check Windows System Requirements

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing:

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

If your computer meets the minimum requirements above, then continue on…

Recommended Method to Fix the Problem: Drop Downs buttons & Comments are disabled in Excel 2007?:

How to Fix Drop Downs buttons & Comments are disabled in Excel 2007? with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  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 fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Chinese (Traditional, Taiwanese) Vs Chinese (Simplified, PRC),CHKDSK Question For Win7 (Will Not Run),Cant View Video In BBC News Website?? Help!,Cant Connect New Compuer To Netgear RangeMax Dual Band 802.11n WNDR3300 Wireless Router,CHKDSK ERROR,Computer Reboots Every Hour,Compromised Hotmail Account,Conditional Format Vlookup,Computer Hangs While I Right Click On An Application,Computer Crashes When Installing Software Or Software Updates,Desktop Background Keeps Going Back To The Standard Background After Reboot,Data Validation In Formulas,Data Validation Custom,Default Excel To Open In Same Instance,DEP Errors While Using Internet Explorer,Song Lyrics As The Poetry Of This Genesis,Partner Relationship Management Guides,Mothers Of The Bride And Groom - How To Break Rules And Still Look Great!,How To Build A Big List Using Social Networking Sites,Trying To Make A Cat Into A Dog
Read More: How Can You Fix - Disk defragmenter is freezing at 33% analysed - left for 6hours and still frozen?,Troubleshoot:Domain Log on for Windows 7 Error,Troubleshoot:Diskpart problem: current read only and read only flags,How to Fix Error - Downloads Randomly Stop for No reason?,dllhost.exe problem (slowing down the pc performance) [Anwsered],DEP Closing Explorer - How to prevent this?,Cursor not visible.,d drive is full, not sure why,Display driver keeps crashing on the computer and receive error message "Display driver NVIDIA Windows Kernel Mode Driver Version 306.97 has stopped working and recovered".,downloading java gives error "This installation package could not be opened. Verify that the package exists..."
[PR]
by HowToSpeedUpC | 2016-09-30 10:19