?
Solved

Mac-based software for Excel

Posted on 2016-11-15
8
Medium Priority
?
62 Views
Last Modified: 2016-11-16
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
Comment
Question by:Martin Liss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 6

Accepted Solution

by:
Michael earned 2000 total points
ID: 41888403
Here's a screenshot of the file in Excel 2016 for mac:

Excel-2016-mac-os-x-screenshot.png
0
 
LVL 49

Author Comment

by:Martin Liss
ID: 41888420
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
 
LVL 6

Expert Comment

by:Michael
ID: 41888477
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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 49

Author Comment

by:Martin Liss
ID: 41888488
The password is Marty
0
 
LVL 6

Expert Comment

by:Michael
ID: 41888560
Once the protection is removed it's working:

Excel-2016-mac-os-x-screenshot-expan.png
0
 
LVL 49

Author Comment

by:Martin Liss
ID: 41888589
Just out of curiosity, are you located in Belgium?
0
 
LVL 6

Expert Comment

by:Michael
ID: 41889259
Yes sir
0
 
LVL 49

Author Closing Comment

by:Martin Liss
ID: 41890708
Thanks.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Microsoft Office 365 is a subscriptions based service which includes services like Exchange Online and Skype for business Online. These services integrate with Microsoft's online version of Active Directory called Azure Active Directory.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question