PowerPivotPro – Excel, SharePoint, and PowerPivot

imageAn interesting post on PowerPivotPro about Automating a report using Excel, SharePoint, and PowerPivot:

“Let’s say you don’t have much need for handling large data volumes, your organization isn’t large enough to worry about spreadsheet robustness/business intelligence/one version of the truth, and you haven’t yet seen what DAX can do for you in pivots.

Or maybe you get some of that, but don’t really understand this whole SharePoint thing.  If you are in either of those boats, here’s an example from my work this weekend.”

Read more here…

Office Blogs Comments

Comments: (1) Collapse

  • I've found this blog very helpful from time to time while I develop VBA macros to make my life easier (I'm an engineer, not a programmer) and I'm wondering what is the most effective way to communicate an Excel bug to the development team?

    For example I've confirmed the following in both Excel 2008 for Mac (on Leopard) and Excel 2003 on XP:

    In a cell: =mod(0.6,0.2) outputs -5.55112E-17 instead of zero.

    In fact I ran a column of numbers starting with 0 and incrementing by 0.1 with a column beside =mod(A1,0.2) with the results either being correct when the answer shouldn't be zero and various unusual numbers when it should be zero.

Comments

Comments: (loading) Collapse