Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 68
  • Last Modified:

Mac-based software for Excel

Can people please  show me what the pivot table in the attached workbook looks like in Office 365 Excel, Office 2016 Excel, and any other mac-based Excel that's still available for legal purchase or download? I'm particularly interested in whether or not the little toggle button shown here at the arrow is available and functional.
ToggleDemo.xlsm
0
Martin Liss
Asked:
Martin Liss
  • 4
  • 4
1 Solution
 
MichaelBusiness AnalystCommented:
Here's a screenshot of the file in Excel 2016 for mac:

Excel-2016-mac-os-x-screenshot.png
0
 
Martin LissRetired ProgrammerAuthor Commented:
Thanks. Does the little toggle at the left of "07 Nov 2016" work? Many of the reviews of 2016 that I've seen have been negative. How would you rate it?
0
 
MichaelBusiness AnalystCommented:
The toggle isn't working; a message pops up that the worksheet is protected.

Overall I'm not a big fan of Excel for mac, in comparison to Excel for windows.
However, I must say that I find 2016 an improvement compared to 2011.
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
Martin LissRetired ProgrammerAuthor Commented:
The password is Marty
0
 
MichaelBusiness AnalystCommented:
Once the protection is removed it's working:

Excel-2016-mac-os-x-screenshot-expan.png
0
 
Martin LissRetired ProgrammerAuthor Commented:
Just out of curiosity, are you located in Belgium?
0
 
MichaelBusiness AnalystCommented:
Yes sir
0
 
Martin LissRetired ProgrammerAuthor Commented:
Thanks.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now