+ Reply to Thread
Results 1 to 4 of 4

Unsupported Formula on Mac for one user but not others

  1. #1
    Forum Contributor
    Join Date
    05-30-2021
    Location
    Colorado Springs
    MS-Off Ver
    Microsoft 365
    Posts
    173

    Unsupported Formula on Mac for one user but not others

    I have an employee whose Mac is treating the following as an unsupported formula:

    The proper formula is this:

    Please Login or Register  to view this content.

    What he sees when he opens the file is this:

    Please Login or Register  to view this content.

    His OS and Excel versions are up to date, and other employees with Macs using the exact same file do not have this problem. There has to be some environmental variable, and the only one I can find is that his version of Excel for Mac is a Retail License whereas the others have the 365 License. Could that possibly be the reason?

    macOS Big Sur version 15.6.2, released 9/13/21
    Excel for Mac version 16.53 (21091200), released 9/14/21

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,613

    Re: Unsupported Formula on Mac for one user but not others

    The dynamic array functions are only available if you have an Office 365 subscription … $A1# is a reference you would use with the output from a dynamic array function like FILTER or UNIQUE.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    05-30-2021
    Location
    Colorado Springs
    MS-Off Ver
    Microsoft 365
    Posts
    173

    Re: Unsupported Formula on Mac for one user but not others

    Great! I didn't want to waste my time changing the license if I wasn't sure it would help, so thank you.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,613

    Re: Unsupported Formula on Mac for one user but not others

    You're welcome. Thanks for the rep.

    https://support.microsoft.com/en-us/...1-87a7eb36e531

    Dynamic array formulas and spilled array behavior

    Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to hide formula in a cell, take user data, but user cannot delete formula
    By jitterbug888 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-23-2020, 07:55 PM
  2. Replies: 16
    Last Post: 11-29-2019, 05:25 PM
  3. [SOLVED] Having user input and a formula (that can incorporate the user input) in the same cell.
    By Super_Bob in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-21-2018, 05:55 AM
  4. Excel: Data > From Web > Unsupported Browser
    By stangz71 in forum Excel General
    Replies: 1
    Last Post: 07-21-2017, 11:07 PM
  5. [SOLVED] automatically updating formula when user adds a user
    By Muzza86 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-25-2014, 06:23 AM
  6. iPhone App unsupported functions
    By Khaldon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2011, 02:06 AM
  7. [SOLVED] Which is unsupported?
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2005, 05:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1