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

Thread: MAC iOS 10.13.3 AND EXCEL 16.10 - problem with Excel formulae

  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
    4,238
    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

  3. #3


    Member Since
    Apr 07, 2010
    Location
    Spanaway, WA.
    Posts
    278
    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
    278
    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,629
    Go Advanced and click on Manage Attachments, in the pop-up that appear, upload the screenshot.
    --
    Regards
    ...Ashwin


  8. #8


    Member Since
    Apr 07, 2010
    Location
    Spanaway, WA.
    Posts
    278
    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,838
    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,629
    Back to the issue at hand, show us the formula you are using and the sample data.
    --
    Regards
    ...Ashwin


  11. #11

    MacInWin's Avatar
    Member Since
    Jan 01, 2009
    Location
    Winchester, VA
    Posts
    4,238
    Yeah, I've just checked again and 16.9 is the latest in Office365, according to MS. Wonder where 16.10 came from?
    Jake

  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
    278
    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
    4,238
    OK, cannot help with beta versions. Suggest the OP goes to MS about the issue.
    Jake

  15. #15


    Member Since
    Apr 07, 2010
    Location
    Spanaway, WA.
    Posts
    278
    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, 12: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, 01: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, 01:16 PM
  4. Mac excel 'read only' problem?
    By sunnyhanda in forum macOS - Apps and Games
    Replies: 0
    Last Post: 10-10-2011, 06:23 PM
  5. Problem with Excel 2011 for Mac
    By Deckhand in forum macOS - Apps and Games
    Replies: 2
    Last Post: 05-29-2011, 09: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
  •