kprincehouse
New Member
Hello,
I'm trying to find the best way to create KPI dashboards (using Excel 2010 on Windows 7) that can be used by both Windows users and Mac users (Excel 2011 for Mac). From what I can tell, there are a few options, none of them perfect. So far, though, it has been extremely frustrating trying to find an approach that yields acceptable results.
I know that many features are not supported on Excel for Mac--Power pivot, slicers, pivot charts, etc. I can try to work around these... but it's the features that supposedly work but do so sightly differently that are killing me. Rows padding my pivot tables magically appear when I open it for Mac, throwing off any formulas or VBA that were relying on the affected cells. As another example, I made some form controls to drive a graph (basically reproducing what slicers normally do); in Windows they work fine, in Mac they work but the graph stutters and lags before updating. I can try to go down this road, making a feature-minimal dashboard to try to get the job done, but I foresee a long, painful journey and a lot of trial-and-error to get it to a decent state.
I've also considered Skydrive, which in many respects would be an ideal solution... but the 5 MB file size limit for web viewing makes Skydrive very unattractive for my purposes.
So my question: Has anyone gone down this road before? Is there an approach, or a set of best practices, or a recommended pared-down feature set I should use in order to build Mac-compatible dashboards that are still pretty, fast, and interactive?
Thank you for any advice!
I'm trying to find the best way to create KPI dashboards (using Excel 2010 on Windows 7) that can be used by both Windows users and Mac users (Excel 2011 for Mac). From what I can tell, there are a few options, none of them perfect. So far, though, it has been extremely frustrating trying to find an approach that yields acceptable results.
I know that many features are not supported on Excel for Mac--Power pivot, slicers, pivot charts, etc. I can try to work around these... but it's the features that supposedly work but do so sightly differently that are killing me. Rows padding my pivot tables magically appear when I open it for Mac, throwing off any formulas or VBA that were relying on the affected cells. As another example, I made some form controls to drive a graph (basically reproducing what slicers normally do); in Windows they work fine, in Mac they work but the graph stutters and lags before updating. I can try to go down this road, making a feature-minimal dashboard to try to get the job done, but I foresee a long, painful journey and a lot of trial-and-error to get it to a decent state.
I've also considered Skydrive, which in many respects would be an ideal solution... but the 5 MB file size limit for web viewing makes Skydrive very unattractive for my purposes.
So my question: Has anyone gone down this road before? Is there an approach, or a set of best practices, or a recommended pared-down feature set I should use in order to build Mac-compatible dashboards that are still pretty, fast, and interactive?
Thank you for any advice!
