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. Fix hyperlink

    I upgraded from Excel 2011 to Office 365 subscription for use on iMac running Sierra 10.13.2.
    For my excel spreadsheets, whereas previous 2011 version with hyperlinks opening jpg images in the hyperlink function was no problem
    In the latest version, I get the message additional permissions required then I have to grant access having looked through lists of jpg images. Please fix this UPGRADED' version of excel for mac.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  2. Use of “Save As” Command Crashes Excel

    I have Excel 2016 for Mac (Office 365) and I find that whenever I open an existing worksheet, edit it, and try to save it under a new name using Excel’s “Save As” command, Excel freezes and I always have to close it using the macOS “Force Quit” command.

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

    We’ll send you updates on this idea

    6 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  3. Use Mac Core Document Behaviours, not Windows paradigms (e.g. for autosave / recover)

    Apps designed specifically for Mac employ Mac Core Document Behaviours, i.e. OS-level methods for handling documents, e.g. autosaving and recovery.

    The issues with Mac Excel's document-handling, particularly after force-quitting Excel or forcing a shutdown of the Mac, or a crash:
    - Excel presents a pop-up on re-opening ('Excel saved changes to the file' etc.): this pop-up burns CPU until you click on it. But the pop-up isn't required if you're handling documents in 'the Mac way' in any case, as other apps do.


    • Excel re-opens docs as 'Last Saved By User' or 'Recovered' (from memory): As a Mac user, I…
    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  4. This workbook contains content that isn't supported in this version of Excel.

    I have an Office 365 subscription. It is loaded on both my Mac and PC. When I create files in my PC I often find they will not open on my Mac. I have to open them as read-only and then save a copy and then delete the PC original so I don't end up with endless copies. I can open the Mac copies just fine on the PC... It would be nice if the subscription worked seamlessly between both my computers.
    I don't use macros or any really 'fancy' functions in my spreadsheets. They are pretty much basic spreadsheets…

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add read-write support for OpenDocument files

    Excel 2016 can now import and export OpenDocument spreadsheets with the help of cloud converter. However, the files are opened as read-only. What is needed is full read-write support for OpenDocument files, so that one can open an ODS file, edit it, and save it.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  6. Fix High Sierra file tag bug - Excel and Word both clear the file tags

    Excel v15.39 clears the MacOS file tags. I had numerous files tagged in MacOS, I upgraded to High Sierra and Excel/Word clear the tags each time it saves the file. Easy to reproduce.


    • tag file

    • open file

    • change something

    • save file

    • tag gone

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

    We’ll send you updates on this idea

    10 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  7. Set default file opening location

    Let the user set the default file location when launching Excel. The default is OneDrive, which I don't use, or On My Mac which is a slow way to where I want to go which is my Documents folder. Let me delete OneDrive, and go directly to the Documents folder where I store my data.

    Excel for Mac used to work this way, but at some point that functionality was woefully changed. I'll never use OneDrive.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow Excel or Word to default to open at My Documents instead of always having to select On My Mac the my documents then Excel or Word.

    Allow Excel or Word to default to open at My Documents instead of always having to select On My Mac the my documents then Excel or Word.

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

    We’ll send you updates on this idea

    0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  9. Format of data from database

    When I open files exported from sql database, the numbers appear, but none can be used. Columns that need to be summed need to be converted to numbers ("Columns to text", then choosing finish, since converting cell by cell takes minutes) or columns to text, choosing text if it is a mixed column of numbers and text that need to be referenced.

    Excel should be able to open them to work with them however, not just as general data that is neither text or value.

    The text problem is related to the way vlookup works where it needs to either…

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

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  10. When saving an xls file, as an xlsx, give the option to replace the xls.

    Files from my company server are all in xls format, but as I work on them I want to save them in xlsx that has the formating and is much smaller in size. As it is, I have to save it to xlsx and then remember to go in and delete the xls file.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  11. Excel launching options

    Please restore the option for Excel to open the last workbook in use when launched, not the wretched Workbook 1, which I have to close 99.99% of the time, and then reopen what I really want to work on.
    This feature was there in 2008, and Googling it shows that lots of people obviously want it back.

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

    We’ll send you updates on this idea

    0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  12. Honor the "Keep Windows" part of "Quit and Keep Windows"

    (This goes not just for Excel, but for all apps in the Office 2016 for Mac suite.)

    I usually have multiple documents open that I work on simultaneously. If I quit Excel, I want all of those documents to re-open the next time I use Excel. Otherwise I have to re-open each of them individually.

    If I hold the Option key while clicking on the Excel dropdown at the top-left of the screen, the "Quit Excel" selection is changed to "Quit and Keep Windows." But when I quit Excel in this fashion, the windows I had open do NOT re-open…

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  13. Right clicking the icon in the title bar should reveal the location of the file (Mac OS X standards...)

    In any other Mac OS X app, when you right click the icon in the title bar, you get a drop down of where your file lives in your file system.

    When you click the enclosing folder, it pops that up in the finder. SUPER handy when you are trying to figure out where you saved that file.

    I have not found a way to do that in Office and it's SO frustrating when Microsoft ignores standards that Mac users expect.

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

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  14. Reopen windows previously open when Excel (or Word) is reopened

    When Excel – and also Word – is reopened, it does not reopen the files that previously had been opened when Excel/Word was closed. This is a VERY useful feature that recent versions of MAC OS, and MS Office, supported. PLEASE bring this feature back to Excel and Word, and PowerPoint as well.

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

    We’ll send you updates on this idea

    6 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  15. Auto file backup

    Prior to 2016, there exist an option set "Auto file backup". When I recently upgraded to 2016, this file backup feature has disappeared. Please bring it back as this is so vital for protecting previous work if I wanted to go back to the previous

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  16. Bring Back Save Workspace

    In prior version one had the ability to open & arrange several windows, then save the arrangement as a "workspace" [.xlw] file. In Excel 2011 the feature was renamed as Save Layout, but is yet another useful capability which has been ripped out in the 2016 release for Mac [I believe the Windows version retains the feature.]

    Please restore that functionality.

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

    We’ll send you updates on this idea

    7 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  17. Microsoft Excel 15.30 (Office 2016 for Mac) and earlier versions cannot open files

    Microsoft Excel 15.30 (Office 2016 for Mac) and earlier versions cannot open files if pathname is long or contains special characters, generating the error message below which is not correct:

    Microsoft Excel cannot access the file... There are several possible reasons:
    • The file name or path name does not exist.
    • The file you're trying to open is being used by another program. Close the document in the other program, and try again.

    • The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook

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

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  18. Keystroke command to open excel to the last file used

    It would really be great if you could enable a keystroke command to both open excel and open to the last file used in Mac Office excel 2016.

    I guess I could learn to write an apple script to do that but I'm a bit challenged at that...also no doubt better if the app engineer is the one fussing with it :-)

    thanks for considering.

    Tom O'Connell

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  19. when opening files in Finder instead of having to go to My Mac or One Drive, show list of all files in folder, same as Excel 2011

    when opening files in Finder instead of having to go to My Mac or One Drive, show list of all files in folder, same as Excel 2011

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  20. Fix the bug that prevents using File Save or File Save As to name or rename or copy a file

    Get rid of the "Tags" line in the File Save and File Save As dialogue boxes. Since this was introduced in an "Update" it causes the Cancel and Save/OK buttons to be off the bottom of the screen and inaccessible. Thus you cannot either Save the File or Cancel the operation ad return to the unsaved spreadsheet. The only way out of this impasse is to Force Quit Excel, thereby losing all prior work, re-starting Excel and starting another spreadsheet.

    The only workaround I have found is to select a file in Finder, use Duplicate File to create a copy…

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    What version of Mac Excel are you running now, and what version didn’t have the issue you’re raising?

    Thanks,
    Dan [MS]

  • Don't see your idea?

Feedback and Knowledge Base