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.

How can we improve Excel for Mac?

(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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add PowerPivot to Mac excel

    is it possible to open an existing Windows Power Pivot Excel on Mac?

    I have already created a Power Pivot Excel report on Excel 2013.
    Now i want to use that report on mac.Is there any way to do so?

    2,120 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    477 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  2. 72 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  3. Provide all the options that are available to Windows users

    MAC users are severely limited with what they can do in Excel compared to Windows users. I am doing an Excel course and creating a Pivot Chart is not an option for me nor do I have the option to create a PowerPivot as my classmates who use Windows PCs. All that needs to be done is to make things comparable. What you do for one- Windows PC users, you do for the other- Mac users. Level the playing field so to speak.

    It's not only about Pivot Tables. All Mac Excel applications and features need to be updated and…

    89 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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?

    71 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Excel for Mac should have the new Stocks functionalty

    It would be great if Excel for Mac (Insiders) is able to have the new Stocks functionality currently used by Excel for PC (Insiders)

    This functonality is described in https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

    In respect of this particular capability, it would bring Excel for Mac more in line with Apple Numbers which currently offers something similar.

    Thank you for considering this addition.

    54 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    35 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add Power Pivot to it.

    Add Power Pivot to Mac for Excel.
    I would be willing to pay an additional fee for it.

    41 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. EXCEL For Mac needs a XML import data

    There is not way to import and map XML data to excel for mac,

    105 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. WeekNum - let it work with a Array like Month() does

    We can use '=SUMPRODUCT( (MONTH(A1:A10)=MONTH(TODAY()) )* (B1:B10) )' to get a result from dates.

    However
    '=SUMPRODUCT( (WEEKNUM(A1:A10)=WEEKNUM(TODAY()) )* (B1:B10) )
    does not, because WEEKNUM can't handle an array or range.

    Please give us a WEEKNUM that handles Array and ranges

    Thank you.

    6 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. what if we added a choice to transfer sheets from bottom to left side instead of column A?

    what if we can add a choice for users to transfer sheets from bottom to left side instead of column A?
    as excel user, I start using first sheet, then second one then third one then I find myself using high NO of sheets which makes finding specific sheet boring and frustrating. and if we have high NO of sheets, it will be harder even if I name the sheets

    but what if we had the ability to transfer all sheets from bottom to left side from top as they fill all column A and column A starts the next…

    6 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. 37 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix ability to open XML files

    Up until Dec 2018 I was able to open an XML file directly in Mac Excel. Last week in Dec and still now I get this message: The file you are trying to open is not a valid Excel XML Spreadsheet.
    I am currently at Mac Excel version 16.20 (181208)

    10 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  12. Make Distinct Count available in value field settings for Pivot Tables in MAC, just like Windows

    Make Distinct Count available in value field settings for Pivot Tables in MAC, just like Windows

    27 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  13. Excel for Mac | Spell Check for different languages

    Make spell check for Excel 2016 work with different languages.

    Spell checker works in other Office Apps (Word, PowerPoint, OneNote, etc.) but not Excel as it only detects English language in Mac OS Mojave.

    Coordinated with Mac Support for possible compatibility issue but they directed the case back to Office 365.

    *tried all troubleshooting steps from this link but still not working
    https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/office-365-2016-mac-excel-spell-check-not-working/a04d5533-5ea5-4d7b-ba33-b044dd5a066e?page=3

    7 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  14. Support Internet Query Connection (.iqy files)

    It would be helpful for Excel to Mac to support internet query connections.

    When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.

    23 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    8 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 →
  16. Pivot Table Power User

    Bring Pivot Tables up to the same capabilities as the Windows version

    40 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  17. Fix copy & paste bug when Handoff (Universal Clipboard) is enabled

    When Handoff is enabled (which also enables Universal Clipboard) and you are signed in to iCloud on your Mac and a nearby iPhone or iPad, Excel will freeze when you try to copy any cell. The spinning beachball will appear for 3-4 seconds and you can't do anything while this is happening. The bug also affects Word. This happens even on a Clean Installed system so it is not a 3rd party conflict.

    I've posted more details and a video of this happening on the Microsoft Community Forums:
    https://answers.microsoft.com/en-us/msoffice/forum/all/copy-cmdc-causes-spinning-beach-ball-delay-for-3-4/36e2e400-59c7-471b-b7d6-b5d5082a545a

    I've tried to report this bug but it seems impossible to…

    8 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  18. Please supply us with a contact phone number for 365 for MAC EASILY found!

    Please supply us with a contact phone number for 365 for MAC EASILY found! I had to literally dig for a while and still don't know if they know anything about 365 with a MAC. Your help features on line are only for Excel 2016. That does NOT help me with a MAC 365.

    1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. New updates

    I see an April 4th update states "The product icons have been redesigned to reflect simple, powerful, and intelligent Office experiences". Sorry, no pass. My idea is that you start to implement all the many ideas and fix the multitude of glitches. Then perhaps we can have a better Office experience.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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…

    19 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 →
← Previous 1 3 4 5 64 65
  • Don't see your idea?

Feedback and Knowledge Base