Office 2016 for Mac is the latest result of Microsoft’s focus on cross-platform apps, and it finally matches its Windows equivalent. The first thing I noticed about using Office 2016 for Mac is.

Test if it is a Mac or a Windows Machine More information about testing the Excel version or Excel language you can find on this page: You can use conditional compiler constants to test the Operating system or test if you run a 32 or 64 bit version of Office. The macro below will test the Operating system, you can replace the msgbox line with your code or Macro call. Sub WINorMAC_1() 'Test the conditional compiler constant #Mac #If Mac Then 'I am a Mac MsgBox 'Call your Mac_Macro' #Else 'I am Windows MsgBox 'Call Windows_Macro' #End If End Sub Office 2011 for the Mac is always 32 bit and Office 2016 for the Mac can be 32 or 64 bit, all builds 15.26 and later are exclusively 64-bit. So every Mac Office 2016 install that is up to date is 64 bit. Below you can find a test macro and three UDF functions that you can use to test the Operating system, test if you run a 32 or 64 bit version of Office and give you the Excel version number.

The Windows version of Microsoft Office has always been the gold standard for office suites, as far as features are concerned. Office exists on other platforms too, like the Mac—but those versions are missing some products and features. RELATED: Microsoft recently announced a. Check out that link for a detailed list of updates, but the big stuff includes bringing some long overdue features to the macOS version, like collaborative real-time editing, automatic saving of documents stored in the cloud, and Google Calendar and Contacts support in Outlook (finally). That said, there are still features (and entire apps) that you might miss out on if you’re working with the Mac version. If you’re switching between Windows and Mac (maybe using one at the office and one at home), or maybe thinking of moving from Windows to Mac, it’s worth comparing the available features in the two versions.

The big question is do you need to or just so that you can run the Windows version of Office, or can you get by with just buying the Mac version (or, better, using one of the installations that comes with your )? What Products Are Missing from the Microsoft Office Mac Suite? RELATED: Microsoft sells Office for Windows in various editions. Almost all editions come with Word, Excel, PowerPoint, and OneNote. Depending on the edition you buy, you might also get apps like Outlook, Publisher, and Access. If you’re using a Mac, though, there are couple of Office apps (and Office-related apps) that you just can’t get: • Publisher: Publisher is an entry-level desktop publishing app, aimed mostly at home users. There’s no Mac version.

While you can easily find comparable apps for macOS, it’s unlikely you’ll be able to bring your Publisher files from the Windows version across very well—at least not without having to work them back into shape. • Access: Access is a relational database management system that comes with the Professional editions of Office for Windows. You can’t get Access on the Mac, so if you (or your company) works with Access databases, you’re out of luck. And while we’re on the subject, there are also a couple of higher end “Office-adjacent” apps that aren’t available on macOS: • Visio: Visio is a diagramming and vector graphics app that lets you visualize complex information in the form of diagrams, graphs, flowcharts, and other forms. There’s no Mac version, so if you need it for work, you’ll need access to Windows. • Project: Project is a project management app that hooks into a company’s Outlook and Exchange Server setup. It lets project managers develop project schedules, create and assign tasks and resources, and manage it all with real-time input from people’s calendars.