Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1


    Member Since
    Feb 12, 2018
    Posts
    4
    MAC iOS 10.13.3 AND EXCEL 16.10 - problem with Excel formulae
    for some reason formulae just don't seem to work. basic formulae adding content of two cells for example come back #value! no matter what i try. formatting cells to number, making sure they are aligned to the right. tried closing down and opening up again in a new spreadsheet. nada. really frustrating.

  2. #2

    MacInWin's Avatar
    Member Since
    Jan 01, 2009
    Location
    Winchester, VA
    Posts
    3,615
    Specs:
    MBP 15" Mid 2015, iPhone 8, an iMac, plus ATVs, AWatch, MacMini
    Welcome to the forum. Version 16.10 for Excel? I have version 16.9 and it reports there are no updates beyond that. When and where did you get 16.10?
    Jake
    The owners have announced that they are going to close this site. Read this and this for details and how to stay in touch.

  3. #3


    Member Since
    Apr 07, 2010
    Location
    Spanaway, WA.
    Posts
    254
    Specs:
    27"iMac OS X 10.7.5 Core i5
    Is it possible that then op is using the Windows version and the version numbers are different?

  4. #4


    Member Since
    Feb 12, 2018
    Posts
    4
    Quote Originally Posted by MacInWin View Post
    Welcome to the forum. Version 16.10 for Excel? I have version 16.9 and it reports there are no updates beyond that. When and where did you get 16.10?
    just double checked. that is the correct version. i have 365 and get regular updates. this must be a very recent one. which doesn't seem to be helping! i i knew how to attach a screengrab of the version i would.

  5. #5


    Member Since
    Apr 07, 2010
    Location
    Spanaway, WA.
    Posts
    254
    Specs:
    27"iMac OS X 10.7.5 Core i5
    Shift Command 4 will Gert you a screenshot. I'm guessing you're using the Mac Version...or does it matter with 365? I just updated mine and 16.9 was the latest for Office 2016

  6. #6


    Member Since
    Feb 12, 2018
    Posts
    4
    just can't see how to attach a screenshot. Insert image doesn't work.

  7. #7

    Raz0rEdge's Avatar
    Member Since
    Jul 17, 2009
    Location
    MA
    Posts
    10,225
    Specs:
    27" i7 iMac, 15" Macbook Pro TB, 13" Macbook Air, iPhone 6S, iPod Nano 7th Gen
    Go Advanced and click on Manage Attachments, in the pop-up that appear, upload the screenshot.
    Mac-Forums is shutting down in the near future. Read this thread to learn more.

    --
    Regards
    ...Ashwin


  8. #8


    Member Since
    Apr 07, 2010
    Location
    Spanaway, WA.
    Posts
    254
    Specs:
    27"iMac OS X 10.7.5 Core i5
    I found that I have to host the image someplace like Posting, then choose the 3rd option from the bottom...

    Edit: I'll try Raz0redge suggestion next time.

  9. #9

    harryb2448's Avatar
    Member Since
    Nov 28, 2007
    Location
    Nambucca Heads Australia
    Posts
    24,661
    Specs:
    iMac, i7 4GHz, 32GB memory, 1TB PCI-e storgae StOS X.13.3
    Excel version 16.9 and Word 16.9.1 here also Jake and right nup to date.
    Hang on to those original install discs like grim death! Using OS X.7 or later make a bootable USB thumb drive before running Installer!

  10. #10

    Raz0rEdge's Avatar
    Member Since
    Jul 17, 2009
    Location
    MA
    Posts
    10,225
    Specs:
    27" i7 iMac, 15" Macbook Pro TB, 13" Macbook Air, iPhone 6S, iPod Nano 7th Gen
    Back to the issue at hand, show us the formula you are using and the sample data.
    Mac-Forums is shutting down in the near future. Read this thread to learn more.

    --
    Regards
    ...Ashwin


  11. #11

    MacInWin's Avatar
    Member Since
    Jan 01, 2009
    Location
    Winchester, VA
    Posts
    3,615
    Specs:
    MBP 15" Mid 2015, iPhone 8, an iMac, plus ATVs, AWatch, MacMini
    Yeah, I've just checked again and 16.9 is the latest in Office365, according to MS. Wonder where 16.10 came from?
    Jake
    The owners have announced that they are going to close this site. Read this and this for details and how to stay in touch.

  12. #12


    Member Since
    Feb 12, 2018
    Posts
    4
    no pop up after i "go advanced". should be more simple to attach a screengrab [which i have saved on my desktop]

  13. #13

    pine man's Avatar
    Member Since
    Jul 15, 2014
    Location
    West Sussex, UK.
    Posts
    253
    Specs:
    iMac 21.5" 3.1GHz Core i7 16GB RAM High Sierra. iPad Air. iPhone 5S. iPod nano.
    It's an 'Insider' version which is something akin to beta testing. The official blurb from Microsoft is:-

    Office is available around the world, and we’re continuously hard at work on exclusive monthly upgrades and new features for Office 365 subscribers. By becoming an Office Insider, you can get early access to the latest Office innovations. Your feedback goes directly to Microsoft product teams and will help make Office even better for users worldwide.

  14. #14

    MacInWin's Avatar
    Member Since
    Jan 01, 2009
    Location
    Winchester, VA
    Posts
    3,615
    Specs:
    MBP 15" Mid 2015, iPhone 8, an iMac, plus ATVs, AWatch, MacMini
    OK, cannot help with beta versions. Suggest the OP goes to MS about the issue.
    Jake
    The owners have announced that they are going to close this site. Read this and this for details and how to stay in touch.

  15. #15


    Member Since
    Apr 07, 2010
    Location
    Spanaway, WA.
    Posts
    254
    Specs:
    27"iMac OS X 10.7.5 Core i5
    My MS Office just updated Word and Excel to 16.10....

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-24-2016, 01:51 PM
  2. Excel for Mac and Excel for Windows
    By newbimac in forum macOS - Apps and Games
    Replies: 5
    Last Post: 09-23-2015, 02:34 PM
  3. Excel 2016 will only open Excel file as read only with Macros
    By mrj002 in forum macOS - Apps and Games
    Replies: 4
    Last Post: 09-14-2015, 02:16 PM
  4. Mac excel 'read only' problem?
    By sunnyhanda in forum macOS - Apps and Games
    Replies: 0
    Last Post: 10-10-2011, 07:23 PM
  5. Problem with Excel 2011 for Mac
    By Deckhand in forum macOS - Apps and Games
    Replies: 2
    Last Post: 05-29-2011, 10:40 PM

Posting Permissions

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