Solved

Excel cell selected - Ribbon frozen

Posted on 2011-09-29
11
2,598 Views
Last Modified: 2012-05-12
I have Office 2007 on Windows 7.

When I am working on a sheet or document the ribbon is inaccessible, nothing works when I click it.
If, I switch to another open sheet/doc and then switch back the ribbon is accessible again!

I have uninstalled/reinstalled Office plus SP's twice but the problem persists.

Any ideas?

Thanks for your time on this

Neil
0
Comment
Question by:NELMO
  • 6
  • 4
11 Comments
 
LVL 17

Expert Comment

by:xtermie
ID: 36814346
Just ensure that you are not in EDIT mode on the other sheet.
Press Enter before you switch to the other document.
0
 
LVL 21

Expert Comment

by:Tapan Pattanaik
ID: 36814418
Hi NELMO,

I have attached screen shot. If you find same issue, then click "Enable Editing" , then edit and save it. If you find other type of issue, please send us screen shot of your excel sheet.

Thanks
Tapan Pattanaik.
enable-editing.JPG
0
 

Author Comment

by:NELMO
ID: 36923986
Sorry neither suggestion is of help.

extermie
It is not just EDIT mode when in a cell in Excel, but also in Word when the cursor is just flashing away and I want choose a formating button from the Ribbon.

tapanpattanaik
Your screen shot is what we sometimes get when we open a spreadsheet sent as an attachment.
This is not the case here.
It can be an Excel (or Word) file that has been worked on before with no problems.

The cursor is flashing on the Word doc, or the cell is selected in Excel and the Ribbon just becomes inaccessible. As if it was a 'Not Responding' screen i.e. clicking anywhere on the Ribbon has no effect.

Thanks again for your time

Neil

0
 
LVL 17

Expert Comment

by:xtermie
ID: 36954157
The problem you describe for Excel or Word (or any other app in that sense) may occur when there are open application windows or processes (foreground or background) or you are in EDIT more in Excel.  For example, if you are in the middle of another process in Word, the ribbon will be inaccessible.  You may have also pressed some button by mistake. for example what happens if you press the alt key - do shortcut letters appear on the ribbon? Could you also try to press ESC when that happens and let us know? (instead of switching to another document)

Also, a collegue had the same problem in Outlook. There may be an issue with the default ribbons.
Try this:
(1) Go to the Outlook folder AppData>Roaming>Microsoft>Outlook
(2) locate outcmd.dat and I rename it
(3) Close all office applications
(4) Windows will recreate the outcmd.dat
Your ribbons will be rebuild and that should work.
0
 
LVL 17

Expert Comment

by:xtermie
ID: 36954160
Reading around, some people suggest that you can also try to delete the quick access toolbar that may be causing this.  Find the .qat extension file for Excel and Word, delete it (with closed applications) and reopen apps. Quick Acc Toolbar will be rebuild as well.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 17

Expert Comment

by:xtermie
ID: 36954181
The application is installed on your computer and is not a virtual one (ie Citrix) correct?
Because for a similar citrix problem there is a solution here
http://social.technet.microsoft.com/Forums/en-US/appvgeneralsequencing/thread/8835a5b1-6756-4902-9fba-a3ee42900cbe
=====
MS have now identifed whats wrong and it is a citrix component called "Special Folder Redirection" which hooks an API-call and then passes it to NT instead of App-V. This confuses office, which keeps trying to to re-read the registry and therfore we get this spinning. So effectively Citrix has overridden APP-V’s hook, and Office doesn’t deal gracefully with the result.

We have never had "Special Folder Redirection" enabled in our enviroment, and I even created a citrix-policy which disables it but this did not help.

What we've done now is that we have renamed "sfrhook.dll" (located in %program files%\citrix\system32\) to "sfrhook.dll.old". Then this hook is disabled and our Excel does not hang anymore.
=====
0
 

Author Comment

by:NELMO
ID: 36968593
Thanks extermie

I will try this when the user returns after the weekend

neil
0
 

Author Comment

by:NELMO
ID: 37480066
sorry
Been offline for a while

extermie
I can't find any files with the extension .qat.
Also I would rather find a solution that does not take any functionality away like the quick access bar.

Thanks

Neil
0
 
LVL 17

Expert Comment

by:xtermie
ID: 37485886
Hey no prob...trying to recall what was the issue here....Now are you viewing hidden files (any explorer window, tools --> folder options --> view tab, select the option to show hidden files and folders.  Then look for a .qat file.

You wont take any functionality away..just the qat will be rebuild to the standard/default.
You can also rename the file .qat and not delete it....
"Reading around, some people suggest that you can also try to delete the quick access toolbar that may be causing this.  Find the .qat extension file for Excel and Word, delete it (with closed applications) and reopen apps. Quick Acc Toolbar will be rebuild as well. "
0
 
LVL 17

Accepted Solution

by:
xtermie earned 500 total points
ID: 37485907
Also check this out...you should be able to find your .qat file
http://support.microsoft.com/kb/926805/en-us?fr=1
2007 Office
Microsoft Office Excel 2007
Excel.qat

In Windows XP, the .qat toolbar files are saved in the following location:
C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Office

In Windows Vista, the .qat toolbar files are saved in the following location:
C:\Users\username\AppData\Local\Microsoft\Office
0
 

Author Closing Comment

by:NELMO
ID: 37604163
thanks extermie

The problem only seemed to be happening with files in a network share.
I followed your solution and also created a new 'offline' folder for him and now I am not sure which solved the problem, but I have to give you the benefit for all your work.
Thanks again
Neil
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office 2010 errors on install 8 31
Excel 2010 - Custom Calculation in Pivot Table 12 50
Excel Formatting test 26 61
VBA excel copy code causing excel to crash 3 36
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

912 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

23 Experts available now in Live!

Get 1:1 Help Now