Does anyone have a good way to share a power pivot report with a Mac user? I’ve tried using excel online with sharepoint but the performance is abysmal and the query is not supported, so updates are manual.

like
Posting as :
works at
You are currently posting as works at

Yes, just tell the person to get a Windows computer, preferably a Dell 😄👍🏼

funnysmart

Dude you’re gettin a Dell!!!

like

Mistake #1: Excel on Mac
Mistake #2: pivot tables

Either (a) transform it to formulas, as should always be; or (b) break the pivot tables and share only the values

likesmart

#1 Yes, I know it’s not ideal, but we don’t always get to work under ideal situations in the real world.

#2 pivot tables work just fine on excel for Mac. The report that I am trying to share, however, relies on DAX measures that are not supported on excel for Mac.

(A) yes, I could convert everything to formulas but there is a level of interactivity and dynamic update to changes in the data that would be hard to replicate. Might be possible, but I’m not trying to spend too much time on it.

(B) is just not a realistic option as I’m trying to create a low-maintenance workflow here and I don’t want to be on the hook for manually updating, saving values, and sharing out every month.

Thanks for the response, in any case.

My next option is to just make the report in power BI but the licenses are weird for sharing reports out of your workspace.

like

Related Posts

How were the raises and bonuses at Deloitte this year? Looking to jump from EY to there

Any financial analysts here?

like

Leo loses Allstate to Droga. I know this was a long time coming, but it’s yet another big loss for Chicago.

like

I need some legit feedback on what is it like to be a UXD at companies like Accenture?
They claim to do a lot of research oriented designs, as everyone. But is that really the case or it's like some other service based companies where the UX is almost vague, and happens mostly based on what the managers think to be good?

Does UX have any value or it's just drafting wireframes based on ideations by the managers and then UI designs?

like

Is Tcs onboarding started in person? My onboarding manager asked me to report to noida for onboarding ,whereas I have asked for gurgaon location and work location on Ibegin also shows Gurgaon. Did she asked for Noida just for onboarding process or the work location will also change to Noida ?

like

Which are Employee perk & benifits at BNY ?

like

Updated my wifi SSID

Post Photo
likefunnyuplifting

I want to be a part of Cyntexa, how can i apply?

like

Anyone have any luck juggling multiple software engineering roles at the same time? I’d like to horizontally scale my work by working many easier, more junior level jobs instead of one very senior, difficult SWE job.

Also, is there a trending name for this sort of thing I can Google for?

likehelpful

Anyone been through the JP Morgan initial phone/recruiter interview? Any insights on questions asked?

like

Hey street photographers, what are your thoughts of people being identifiable in shots?

like

Hi,
Is there pickup drop cab services in DLF Ramapuram.I need to go to my new office
CGI.

Also,Which is the fast route to reach by train or bus?CGI

Hi Fishes,

I have 2 offers in hand

1. PPD, part of thermofisher scientific - 14 LPA + 2L JB
Permanent WFH

2. TSYS - 17 LPA+ 1L JB Hybrid WFO

YOE: 3+ years

Which company would be better considering the upcoming recession?

like

Just joined this bowl and disappointed to find 80% of the posts are just people too lazy to read their employee handbook... I’m here to ask, any firms offers MilkStork as a benefit.

likefunny

so should I sell dodge? lol

funny

Anyone here that has exited to a retail mortgage or lending strategic in a Corp Dev / M&A role? Would like to hear experiences on work products, culture, etc.

like

Anyone have insight on working in Patreon’s legal department?

like

Calling all ID Associates: Do you expect a cost of living raise from one year to the next? My mid-size ID firm did not give any associate raises for 2021-2022 and a wave of associates quit in response. I’m anxious 2023 will be no different. What’s the expectation?

like

Hi Friends,

I didn't get relieving letter from EY GDS and its been more than 15 days that I had resigned from company and no one is responding except that automated response when I mail to myhr@gds

Requesting you to provide any mail so that I will mail them to get it complete asap

Please help!!

like

Hello fishes, what should be the right salary range for 9.5 yoe in development. Technology is Python and Java. Amazon Newco Larsen & Toubro Infotech IBM Tech Mahindra

like

Additional Posts in Excel Genius

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

How long did it take you to become good at excel? Like fast?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

How do you fix microsoft excel cannot paste data error?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Would anyone be willing to teach me vlookup?

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal