The instructions you've linked clarify that there is no way to show an Active account that has no activity:
- Choose which rows or columns to show:
- Active: Hide empty rows and columns.
- All: Show all rows or columns.
- Non-zero: Hide rows and columns with a total of zero.
This is extremely confusing, since the "Active" label leads one to think that they are going to be able to see all Active Accounts, when active is actually referring to filtering out accounts that have no transactions. This wreaks havoc to the linked cells on my excel budget reports when suddenly an account has a transaction and adds another line to the profit and loss.
The only "solution" I came across is from another user who was entering a 0 transaction at the beginning of the year in every single Active account to make sure it came up in the profit and loss report.
