[Bug]: property color cannot be found and error editing PivotTable

[boletus151]

Description

When running Azure Resource Inventory (ARI) against multiple subscriptions, using the following code:

try {
    Invoke-ARI `
        -TenantID $TenantId `
        -SubscriptionID $SubId `
        -SkipVMDetails `
        -ReportDir $OutDir `
        -Debug

    Write-Host "OK: Output saved to $OutDir" -ForegroundColor Green
}
catch {
    $msg = $_.Exception.Message
    Write-Host "❌    ERROR: $SubId -> $msg" -ForegroundColor Red
}

ARI sometimes fails with the following error:

The property 'Color' cannot be found on this object.

• This happens even when -DiagramFullEnvironment is NOT used.
• The error appears at the end of Excel report generation phase after following debug info is printed:

"Validating if Excel is installed (Extra Customizations)"
"Error interacting with Excel COM object"

• Furthermore, the Excel is generated but when it is opened appear a window multiple times with the following message:
  "Cannot edit PivotTable on protected sheet"

Conditions / Observations

• The error occurs only for some subscriptions, not all.
• The same command works without error for other subscriptions (probably with a lower level of resources).
• The error is resource-dependent (subscription content / structure), not random.
• Removing -DiagramFullEnvironment does not always prevent the error.
• The error happens late in the execution.
• The Excel report file is still created, without diagrams and opening error warnings the first time the file is opened

[juanandmsft]

The error is caused when Excel configuration forces it to use AIP labels.
As a quick'n'dirty workaround, you can modify Build-ARIExcelComObject.ps1 as follows (use "Import-Module AzureResourceInventory -Force" to reload):

With this, after the script pauses, you can open the spreadsheet, accept all "Cannot edit PivotTable on protected sheet" messages, set AIP label, save spreadsheet and close it. Then let ARI continue.

Hope it helps :)