• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Pixcels.nl

  • Home
  • Categories
    • Excel apps
    • Pivottable stuff
    • PowerBI stuff
    • RGS en auditfiles
    • Sheet stuff
    • Userform stuff
    • VBA stuff
    • VBE stuff
    • XML stuff
  • About
You are here: Home / Archives for Categories / Excel apps

Excel apps

Replace drill-through for Power Pivot and Power BI pivottables in Excel

2020/09/22 by Frans

Excel’s default drill-through for pivottables connected to a datamodel or Power BI dataset is often not very helpful. The add-in PowerDrill for Excel replaces Excel’s drill-through and gives you full control over the drill details.

[Read more…] about Replace drill-through for Power Pivot and Power BI pivottables in Excel

Filed Under: Excel apps, PowerBI stuff Tagged With: drill-through, PivotTable, Power BI

AuditfileValidator for Excel: validate and inspect Xml auditfiles

2020/09/20 by Frans

AuditfileValidator is an Excel addin that validates the most common auditfile formats and versions (XAF, XAS, XAA, SAF-T, etc) against their schema, and presents an overview of the most important properties of the auditfile.

[Read more…] about AuditfileValidator for Excel: validate and inspect Xml auditfiles

Filed Under: Excel apps, RGS en auditfiles Tagged With: auditfiles, validate, xml