Documentation

This documentation explains how to install, configure, and use Portfolio Slicer, including how to prepare data, refresh reports, work with scripts, and troubleshoot common issues.

If you are new to Portfolio Slicer, start with the guides in the first section below.

Start Here

If you are new to Portfolio Slicer, read these pages first:

• What is Portfolio Slicer?
• System requirements
• Install Portfolio Slicer
• First time users guide

Understand the Data

These pages explain what data Portfolio Slicer needs and how it is organized:

• Required data overview
• PortfolioSlicer-Source.xlsx file
• Data management script set
• Files prepared for Portfolio Slicer reports
• Portfolio Slicer Excel & Power BI reports
• Data FAQ
• Known limitations

Legacy and Version-Specific Topics

Older documentation is kept for users working with legacy versions or older Excel setups:

• Upgrade from older versions
• Migration to v3.x from older version
• Excel 2010 and PowerPivot
• Excel 2010 refresh data
• Excel 2010 change data location

Portfolio Slicer is powerful, but it expects a more hands-on workflow than a typical consumer portfolio app. These docs are meant to help you get to a reliable working setup and understand how the system behaves once it is in place.