I have PowerShell scripts that automate process and loads the result into Excel. I use the following statement on box where Office16 installed. After running the below command the $excel variable is filled with information about the object. When I use the statement on a machine where Office 365 Enterprise is loaded the value of $excel has the structure but no values.
$excel = New-Object -ComObject Excel.Application
I need to understand why this is happening and how to resolve the issue.