Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Whenever I select multiple Excel (2010) files the right mouseclick option 'open' disappears. When I select just one or a few files there is no problem, but from 15 or more files I can't open them at once anymore.

In the picture you'll see there is no 'open' option. Usually this option is above 7-Zip along with 'New' and 'Print'

excel open option missing

Can anyone tell me why this is happening and how I can change this?


share|improve this question
Can you repeat this behaviour with Word? I suspect this is to prevent opening too many files accidentally. What happens when you Shift-Right-click? – user3463 Sep 14 '12 at 7:27
up vote 6 down vote accepted

Windows removes certain options from the context menu when more than 15 items are selected. According to this Microsoft KB article, that's by design, to prevent accidentally performing those actions on a large number of files.

You can, however, change that limit in the registry. From that same KB article:

Name : MultipleInvokePromptMinimum
Type : DWORD
Default : 15 (decimal)

Setting the value to 16 or higher effectively removes the limit.

share|improve this answer
Nice, thank you! – jagsler Aug 16 '12 at 10:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .