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!

This is an old request for the date picker since Microsoft removed the feature. I have copied an admin response and request for votes starting from 2016.
How is it possible after 5 years there has not been any advancement on this?

With the amount of people that utilize Excel, you are not supporting your customer's needs.
Please get your coders to rectify this as soon as possible. This delay is not acceptable by any means.

Add 'date picker' to enable users to select a date from a mini calendar into cells
2,425
votes
Vote
Figures shared this idea · April 01, 2016 · Flag idea as inappropriate…
STARTED ·

ADMIN
Excel Team [MSFT] (Product Owner, Office.com) responded · August 07, 2018
Hi all,

We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

Thanks!
Blake, Excel Product Team

Show previous admin responses (5)

Training the Street, Inc. (TTS) is a prominent Wall Street financial modeling company that trains the majority of Wall Street/finance firms in the United States. TTS has developed an Excel Add-in that thousands of professionals use to enhance their Excel modeling speed. But since Office 365 has started churning out rapid updates, the Add-in has become unreliable and TTS has stated they no longer are making the updates necessary to counter Microsoft's changes. https://trainingthestreet.com/macros/

Is there a way your Dev team could look at this simple Excel Add-in and find a way to add it to the Microsoft Office Add-in Store in a form that would stay compatible with future Microsoft Excel updates and be deployable by Admins to many in their companies. https://trainingthestreet.com/macros/

Personally I can't stand using Excel without this macro. I simply have to resort to mouse clicking vs. quick keys and learning a new set of MSFT based quick keys is not something those who wish to use a certain add-in should be forced to spend time on.

Thanks in advance for your time and consideration,

Jim Spielman

The Spreadsheet Compare tool/add-in should show the user the list of changes between workbook 'A' and 'B' (functionality exists) and then allow the user the ability to group changes together (new functionality). It should then generate as set of workbooks that move from 'A' and add make the changes of each change-group. The changes would be cumulative so the final workbook produced would match 'B'.

The user should then be able to select a cell in the workbook 'B' and the tool should read from the set of workbooks (as created in the previous paragraph) to show how the value of the selected cell changed. This could be in a list [A; value, step 1: value, step 2: newvalue; B: finalvalue] which could be then the used to produce a waterfall chart.

This would be helpful to allow users to see how key values in the spreadsheet changed as a result of a change of inputs into the workbook, or formulae changes in workbooks.

Dear Excel-Team,

Unfortunately, I don't have the Feedback-button, therefore I would like to post a bug here. Thanks for your understanding.

in Version 2104, checkboxes within a UserForm are activated when approached by arrow keys (w/o mouse click or space bar). When for example a user navigates from one textbox to another using the arrow keys, all checkboxes in between will be activated. The checkboxes remain activated when approached again by arrow keys.

This behavior doesn't seem to be intended as it was different in earlier Excel versions.

Please see also the Microsoft Community Post, there is also a link to a short video: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/checkboxes-are-activated-by-arrow-keys/2cdfd092-3b4c-4077-9e7a-4e61a8e2d612?messageId=aac89c26-3e34-4531-858d-ddd60ef3da10

Thanks and best regards,
Christian

Crossposting from here: https://answers.microsoft.com/en-us/msoffice/forum/all/i-have-a-reproduceable-bug-in-excel/c1f18efd-2f7c-494b-84df-b81fac32bb21 , where a moderator discovered that it's happening when the first part of a filename is also a cell address, like A1 - XFD9999 or the like.

Make a new workbook, add a new module to it in the developer IDE.

Put this code in the module. The function just makes a button on the first tab. That button, when pressed, will pop up a messagebox saying "Hello World". (.....sorry, pasting in here blew up my indentation and I can't seem to fix it!)

Function makebuttons()

Dim wb As Workbook

Set wb = ThisWorkbook

Dim ws As Worksheet

Set ws = wb.Sheets(1)

'this function makes a new shape each time it's called, let's delete them out so we don't get a million of them

Dim ourshape As Shape

For Each ourshape In ws.Shapes

ourshape.Delete

Next ourshape

'need to make and assign the following buttons:

Dim btn As Button

Dim aaa As Range

Set aaa = ws.Range("B14:D17")

Set btn = ws.Buttons.Add(aaa.Left, aaa.Top, aaa.Width, aaa.Height)

With btn

.Name = "mainbutton"

.Caption = "The Button"

.OnAction = "showTheBox"

End With

End Function

Sub showTheBox()

MsgBox "Hello World"

End Sub

1. In the ThisWorkbook object, put this code (just for ease of use, it'll then run when you open the workbook:

Private Sub Workbook_Open()

Call makebuttons

End Sub

1. Save as an XLTM. Call it whatever you want, as long as it's not between 1 and 3 letters, followed by at least one number, followed by a space, followed by whatever else you want. For example, not this: "bb8 star wars.xltm" (without quotes) or "abc99 whatever", but you could do "bb8starwars.xltm".

2. Attempt to open the file by double-clicking. It will fail on the .OnAction call. You'll probably have to use the task manager to kill excel.

3. Rename it (via right-click) so it's in some other form, like going to "abcd8 star wars.xltm" (without quotes) or “bb8starwars.xltm” instead of "bb8 star wars.xltm".

4. Double-click, the new file created from the xltm will now open normally and the button will appear as it should. You can also try this all the other way, name it an allowable name when you first save and then rename it to something non-allowable, the failure will happen either way.

I don't actually need any advice (I'm going to just tell my lab to rename the XLTM and it should work as intended), but I couldn't find any easy way to put in a bug report other than here. I'm on 365 for Enterprise, version 2008 (Build 13127.21624 Click-to-Run), on Windows 10, v1909 build 18363.1556