Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 301 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Only very specific versions of Office 2013 allow PowerPivot
Miklos_Hollender
Member Posts: 1,598
Unlike in Excel 2010, it is not downloadable separately. It is either there or not. And only PowerPlus, 365 PowerPlus and Standalone have it. E.g. we are using in a subsidiary Home and Business version and it is not there.
https://support.office.com/en-ca/articl ... field_list
Note that it is not that hugely useful anyway. I have tested it by linking it to the Item, Sales Line and Item Ledger Entry tables, creation connections between them based on Item No. and then have put a Pivot Table on it. It worked so far that I could make table where rows are item numbers and there are two value columns, summing quantities from each. It is good so far, but it was not possible to set up a proper report, where each calculated column has different filters: say Sales Order Quantity or Inventory/Sales Quantity for Jan, Feb, March...
Well, that is pretty much rubbish anyway...
... we can do without it, I am just saying it mainly to partners that it can be a big embarrassment when you sell NAV and promise Power Pivot to customers and then it turns out their Office does not support it.
Excel Standalone is $99 on Amazon but I think USA only.
https://support.office.com/en-ca/articl ... field_list
Note that it is not that hugely useful anyway. I have tested it by linking it to the Item, Sales Line and Item Ledger Entry tables, creation connections between them based on Item No. and then have put a Pivot Table on it. It worked so far that I could make table where rows are item numbers and there are two value columns, summing quantities from each. It is good so far, but it was not possible to set up a proper report, where each calculated column has different filters: say Sales Order Quantity or Inventory/Sales Quantity for Jan, Feb, March...
Well, that is pretty much rubbish anyway...
... we can do without it, I am just saying it mainly to partners that it can be a big embarrassment when you sell NAV and promise Power Pivot to customers and then it turns out their Office does not support it.
Excel Standalone is $99 on Amazon but I think USA only.
0
Comments