Microsoft appears to have added this as a new 'feature' in Version 2006 (Build 13001.20266 Click-to-Run) and it's a disaster. For a workbook with a large number of protected sheets the visibility of sheet tabs is reduced by ~ 30%, thereby greatly reducing user-friendliness and the ability to navigate around the workbook using sheet tabs.

I've attached a screen grab of a basic model containing protected sheets which has lost visibility of at least 3 sheet tabs as a result of the unnecessary and unwanted lock symbols on almost every sheet.

This 'feature' needs to be removed or made optional and OFF by default.

The new Information Rights Management (IRM) is great to protect workbooks from being opened or edited by non authorized users.
Unfortunately it also deactivates all ad-ins. In principle this makes sense as add-ins can access and modify information within the workbook. However, current restrictions go a bit too far as even as an owner/author of the workbook with FULL CONTROL my add-ins are deactivated. Should I not have full rights to do anything with the workbook? In our company thousands of users across EMEA use a self developed add-in to calculate service costs. Now they cannot use IRM as it would block this add-in.

FEATURE REQUEST:

Under "Additional permissions for users" can you please add any of the following options

"allow all add-ins"
"select a specific add-in to be allowed"
"allow all users with FULL CONTROL to use add-ins"

Thank you!

Correção na documentação da função SOMA.

Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255 "números"para de 1 a 255 argumentos que podem ser números, célula, intervalo de células, funções ou fórmulas.

Corrigir descrição da opção "Remover Duplicatas" no Microsoft Excel

No caminho Dados>Ferramentas de Dados temos a opção "Remover Duplicatas".

"Duplicatas" no Comércio significa: "título de crédito nominativo pelo qual o comprador fica obrigado a pagar, em determinada data, a quantia correspondente à fatura de mercadoria vendida a prazo."

Ao deixarmos o mouse na opção já aparece "Duplicatas" que está errado por fazer confusão ao comercio, e no texto em seu "balão" aparece como "Duplicadas", onde o seu único significado é "que ou o que se duplicou; que foi copiado por uso de artefato próprio ou manuscrito (diz-se de documento ou escrito).

O mesmo erro ocorre ao selecionarmos a opção na janela de opção de colunas à remover onde na mesma linha consta inicialmente como "Duplicadas" (correto) e no final como "Duplicatas" (errado)

Segue anexos para melhor entendimento.

From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.

Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA user-defined function that performs each of the substitutions for you.

The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the Replace parameter.
=SUBSTITUTES(text, OldTextArray, NewTextArray, optional InstanceNum)

If NewTextArray is a single value, then each of the values in OldTextArray would be replaced with that single value.

If NewTextArray matches OldTextArray in dimensions, then an element of OldTextArray is replaced with the corresponding element of NewTextArray.

If InstanceNum is omitted, then all matches are replaced. If InstanceNum is a positive integer, then just that instance is replaced. If InstanceNum is a negative integer, then just that instance (counting from the end of the string) is replaced. If the absolute value of InstanceNum exceeds the number of matches, then all matches are replaced.

To remove punctuation from the text, you might use:
=TRIM(SUBSTITUTES(A2, {",",".","?","!",";",":","_","-"}," "))

To replace the last comma with an ampersand, you might use:
=SUBSTITUTES(A2, ", ", " & ",-1)
This formula would turn "dog, horse, mouse" into "dog, horse & mouse"

Everyone is using Data Validation in Excel for simple or complex projects. However if you decide to clear your data validation rules there is No direct command on the ribbon to do that: So you have to go to the Data Tab >> Open the data Validation dialog box >> Click on Clear All >> Close the dialog Box.
My suggestion is to integrate this functionality with the Data Validation button in the ribbon (as explained in the attached Graphic) which will enable the user with a click to either clear Data Validation from a selected range or from the entire worksheet (as in case of Conditional Formatting)
I designed the proposed look of the Data Validation button.