Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

How can we improve Excel for Mac?

Enter your idea

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.

(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)

Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

I updated the title and description for this one and we’ll continue to monitor for comments and votes.

Solver in the latest version of Excel for Mac gives wrong answers to problems with binary variables. I am a professor and I teach an optimization class where this is a big problem. Running Solver in the attached file (and many others) generates wrong answers in the latest Excel for Mac. It works fine in other versions of Excel, including Excel for Mac 2011.

I'm building an Excel spreadsheet tool that I would like to be compatible across different versions of Office. It's not terribly complicated; just a few sheets and buttons that allow you to manage data & do some basic analysis. I was able to make it completely compatible with Excel 2011 for Mac by using only form controls and by getting rid of any "Missing" references in the VBA editor, but in Office 2016, I get errors trying to set the value of a drop-down/combobox using .ControlFormat.ListIndex or .ControlFormat.Value. Both versions work fine in Excel 2010 & 2013 for Windows and in 2011 for Mac, but Excel 2016 for Mac throws an error. I've been unable to find any documentation online that helps explain the differences, and it's been very frustrating.

I'm building an Excel spreadsheet tool that I would like to be compatible across different versions of Office. It's not terribly complicated; just a few sheets and buttons that allow you to manage data & do some basic analysis. I was able to make it completely compatible with Excel 2011 for Mac by using only form controls and by getting rid of any "Missing" references in the VBA editor, but in Office 2016, I get errors trying to set the value of a drop-down/combobox using .ControlFormat.ListIndex or .ControlFormat.Value. Both versions work fine in Excel 2010 & 2013 for Windows and…

Excel for Mac version 16.15 does not open xlsm files from Excel for Windows !

Excel has a very serious error:
Do not open the xlsm files maked with Excel for Windows, please correct it... !!!

I have tried it with all my previous excel macros files and in all it sends me a message of ERROR, when accepting that, Excel proceeds to repair it deletes all the macros that you have programmed in VBA !!!

What kind of error is that ???

PLEASE CORRECT THAT HORROR !!!! ...

The exact message is the following:

Notice: We have found a problem with 'book.xlsm' content. Do you want us to try to recover as much content as possible? If you trust the origin of this book, click Yes.

When I answering YES, all the VBA code is deleted and lost !!!
Very careful Danger of losing your VBA macros !!! ￼

Microsoft: ¡ please correct this error !

Excel for Mac version 16.15 does not open xlsm files from Excel for Windows !

Excel has a very serious error:
Do not open the xlsm files maked with Excel for Windows, please correct it... !!!

I have tried it with all my previous excel macros files and in all it sends me a message of ERROR, when accepting that, Excel proceeds to repair it deletes all the macros that you have programmed in VBA !!!

ActiveWorkbook.Connections("ConnectionName").ODBCConnection is broken. Please fix this single command. It is a blocking issue. All other ODBC commands are working as expected. Please fix this one so everything is working. Thanks

The "Application.MacroOptions" as described but the Microsoft documentation https://msdn.microsoft.com/en-us/library/office/ff838997.aspx does not appear to be fully implemented for Excel 2016 MAC. The argument "ArgumentDescription" that is described in the Excel VBA reference causes a compile error to be raised. How about full implementation of the Application.MacroOptions.

In Excel 2016, it is not possible to set the top position of an Excel window, neither with the VBA call 'ActiveWindow.Top = 100' nor with the AppleScript call 'set top of window 1 to 100'. This was no problem in Excel 2011. Please bring back this functionality.

Need to fix a bug with mac Excel. After running a macro, the mouse cursor disappears. It reappears after typing in another program and coming back to Excel. This fix works sometimes but not all. This gets frustrating. The same macro runs fine in Windows Excel.

For many years I had a customized set of buttons in the toolbar at the top of Excel spreadsheets. Some of these were standardized commands (splitting the worksheet); others were macros I had created. These sped up my work significantly. I had hoped to use the Quick Access Toolbar in Excel for Mac 2016 to recreate the most important of these. I can do this, but they all have the same button symbol!! Could you allow me to replace the buttons with symbols, as I could in Excel for Mac 2011 and apparently could if I used Excel 2016 for Windows?

For many years I had a customized set of buttons in the toolbar at the top of Excel spreadsheets. Some of these were standardized commands (splitting the worksheet); others were macros I had created. These sped up my work significantly. I had hoped to use the Quick Access Toolbar in Excel for Mac 2016 to recreate the most important of these. I can do this, but they all have the same button symbol!! Could you allow me to replace the buttons with symbols, as I could in Excel for Mac 2011 and apparently could if I used Excel 2016 for…