Feedback by UserVoice

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. ADD creating & edditing UserForm in Excel VBA for MAC

    it is not possible to creating or editing UserForm in Excel VBA for Mac.

    11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  2. Excel 16.29 for Mac the solver doesn't work...

    Solver shows in the tools but it doesn't work after bing selected.
    Please solve it !!!

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. Create equal functionality for Mac users such as Power Query.

    Allow Mac users to access all add-ins such as Power Query. We are paying the same price but getting inferior service.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow Keyboard Shortcuts in VBE

    The visual basic for applications editor for the Mac does not have the ability to edit keyboard shortcuts. The most common editing shortcut used is to step through code while debugging. In windows VBE this is F8, and those of us who are familiar with the windows version would like to have the same experience on the Mac. The current keyboard shortcut requires two hands and makes it very awkward to step through and debug your code.

    According to Madoc Huang MSFT in the Microsoft community forum, I should post this here because this feature is not available on the…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Bring VBA on Excel for Mac to parity with Excel for Windows

    Bring VBA on Excel for Mac to parity with Excel for Windows.

    Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

    Why is the not being addressed?

    94 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add Userforms to VBA in excel for Mac

    UserForms are not available in excel for Mac users

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. Refresh a power query

    Allow Mac users to refresh a Power Query that gets files from a folder (and was created with windows).

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. Interrupt running macro

    On Windows, Ctrl+Break can be used to interrompt a macro (for instance, stuck in an infinite loop).

    Excel 2011 used to have this option too, via Cmd + .

    However, this shortcut doesn't work on the latest versions of Excel for Ma and there is no way to interrupt a macro except than force quitting.

    (Tested on 'classic' Excel 2016, and 'Mac App Store' edition of Excel 16.28).

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. VBA compatibility between Office 2016(16.16...) and Office 2019 (16.26)

    I recently notice that files saved with Office 2016 do not work on Office 2019 (16.26) and vice et versa. Either crash or showing compilation error or internal errors with librairy. It was not the case with Office 2019 (16.25).
    Please fix...

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. VBA-Fehler bei double

    Das folgende VBA-Programm erzeugt in der dritten Zeile einen Überlauf-Fehler:

    Sub Test()
    Dim a As Double
    a = 18.9
    End Sub

    Auf Windows läuft das Programm fehlerlos. Bitte korrigieren.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix ExportAsFixedFormat method

    ExportAsFixedFormat method produces a "Run-time error '1004':

    Application-defined or object-defined error" when trying to save (export) a pdf to a user folder (/Users/user/Documents for example)

    As I see it only works if one saves to the sandbox path of Office (Library/Group Containers/UBF8T346G9.Office), which is quite uncomfortable to work with.

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  12. Ability to name and place icons on macros added to the Quick Access Toolbar

    When a macro is added to the QAT, it displays as a circle in the toolbar. Add another, you get another circle. Unless you memorize what you added and the order you added them, you don't know what you're selecting. The list for customizing the QAT shows them as <<No label>>. You can name them with the Rename option on gear at the bottom of the dialog, but they revert back to no label after you exit the dialog.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. Switching from Excel 2011 to Excel 2016 - Need a migration guide for VBA. 2016 does not run my 2011 macros correctly.

    There appear to be critical compatibility issues between 2011 and 2016 for Mac.
    I've written a lot personal finance code. I need to load externally generated tab separated data and expressions into excel cell ranges. I export named range tables so my external code can inter-operate with Excel 2011. The macros I wrote to do all this in Excel 2011 don't run correctly in Excel 2016. I need a comprehensive Macro/VBA migration guide. I can't switch to 2016 until these macros have been ported.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. Invoicing using a hand held scanner so that we can add barcodes automatically

    It would be excellent if we had facilities to scan a barcode from a hand held scanner in to an invoice

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Excel for Mac 2016 does not open xlsm files from Excel for Windows !

    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…

    20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add customized footer for each page

    I would like to enter a customized footer for each excel sheet that I print. For example page 1 footer is different that page 2 but I still able to keep the feature of all of them having a consistent page number.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Fix HTML export from AppleScript

    Since 16.15, running the following AppleScript has either crashed Excel (versions 16.16–16.23) or (16.15 and since 16.24) produced a badly formatted HTML file.

    tell application "Microsoft Excel" to save as active sheet filename theFolder & "test.html" file format HTML file format

    Note that theFolder is a valid folder in the Office sandbox folder. The equivalent code in VBA works fine:

    ActiveSheet.SaveAs FileName:=theFolder & "test.html", FileFormat:=xlHtml

    Alternatively, could the VBA PublishObject object be added to the AppleScript dictionary?

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. Easy or even just available data forms for data input on Office 2019

    We just need the basic data forms available to us! UGH it's ridiculous not to have that available and even readily available

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. Mouse cursor disappears after running a macro in Excel for Mac version 16.15

    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.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Feedback and Knowledge Base