We help IT Professionals succeed at work.

Add Multiple Table to a PivotTable with Excel for Mac

79 Views
Last Modified: 2017-05-29
hi Excel folks

this is a question for Excel for Mac only as the required option "add the data to the data model" is available when creating a PivotTable with Excel for Windows. i just can't find the same option with my Excel 2011 for Mac.

any suggestions please?

thanks,
bbao
Comment
Watch Question

Zack BarresseExcel Dev
CERTIFIED EXPERT

Commented:
You don't have that option in Excel 2011, it doesn't exist. Power Pivot is for Windows-based Excel only. Sorry.
bbaoIT Consultant
CERTIFIED EXPERT

Author

Commented:
thanks for the feedback. as far as you know, is there any method to do the same or similar thing on the Mac version?
Excel Dev
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
bbaoIT Consultant
CERTIFIED EXPERT

Author

Commented:
is it possible to implement the same or similar function using VBA macro? just a thought as i don't really use macro due to security concerns. thanks for your help.
Zack BarresseExcel Dev
CERTIFIED EXPERT

Commented:
The same, no, there is no Power Pivot for Mac. Similar, it depends. We can do a lot with VBA, but to mimic Power Pivot would be a very large undertaking. If you had a specific requirement you would need to post that.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.