Results 1 to 5 of 5
  1. #1


    Member Since
    Sep 11, 2015
    Posts
    2
    Excel 2016 will only open Excel file as read only with Macros
    OK - I am VERY new to OSX. I have an excel file with some basic macros that go out to yahoo.com finance and download stock data. It also does some custom sorting for columns.

    When I moved this file over to my new MacBook and tried to open it in Excel 2016 - it states This workbook contains content that isn't supported in this version of Excel."

    The macros than appear to not be present in the file when opened in read only.

    Can someone help me with what is going on. I was under the impression the excel 2016 for Mac supported VBA macros.

    Thanks

  2. #2

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    50,772
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, Sierra
    Office 2011 and Office 365 do support macros. However, if your macro was written for the Office version of Excel 2016 it may not work with the Office 365 version of Excel you're running on your Mac without recompiling it. Either that, or you may have macros turned off in Office 365. (A stand alone version of Office 2016 has not yet been released for the Mac.)

  3. #3


    Member Since
    Sep 11, 2015
    Posts
    2
    Sorry - I was not really clear in my first post.

    The macros were written in Excel on a PC - I then emailed them to myself and put them on my MAC desktop. When I open the file in Office365 I get the error "This workbook contains content that isn't supported in this version of Excel."

    It then appears that the macros no longer exist.

  4. #4

    MacInWin's Avatar
    Member Since
    Jul 07, 2008
    Location
    Winchester, VA
    Posts
    6,969
    Specs:
    2015 rMBP, 2008 iMac, iPhone 7, iPad mini, 13" MBP, AppleTV and two MacMinis
    See if you can recreate the macros in the Office365 on the Mac. If you can, you've got them. If the functions you used on Windows aren't there in OS X, then complain to MS to add them to the OS X version. That's about all I can think of to help. If Excel refused to read the macros, there isn't any way to force it to do so.

  5. #5

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    50,772
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, Sierra
    Quote Originally Posted by mrj002 View Post
    Sorry - I was not really clear in my first post.

    The macros were written in Excel on a PC - I then emailed them to myself and put them on my MAC desktop. When I open the file in Office365 I get the error "This workbook contains content that isn't supported in this version of Excel."

    It then appears that the macros no longer exist.
    As I stated in my first reply, you likely will have to recompile the Excel macro in order to get it to work with Office 365. I have had to recompile Word macros before, so it would depend on your knowledge of VBA whether or not your macro(s) will run. When Office 2016 is finally released stand alone for the Mac, it won't matter as you will run into the same problem. And don't expect MS to change things.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Read Excel File
    By manga in forum iOS Development
    Replies: 3
    Last Post: 04-30-2013, 08:15 AM
  2. Macros in Excel from windows
    By bnoble in forum OS X - Apps and Games
    Replies: 4
    Last Post: 05-02-2012, 09:57 PM
  3. i need to enable Macros in excel HELP!!!
    By unders0007 in forum Running Windows (or anything else) on your Mac
    Replies: 4
    Last Post: 11-30-2010, 02:17 AM
  4. excel macros
    By fatfish in forum OS X - Apps and Games
    Replies: 2
    Last Post: 02-11-2010, 12:19 AM
  5. OS 10.3.9 Excel Macros
    By PHoMAC in forum OS X - Operating System
    Replies: 0
    Last Post: 05-02-2006, 10:31 AM

Posting Permissions

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