I am downloading an xlsx file linked to a MS Form (so each new row is a new form submission) from Sharepoint and importing it in Powershell via ImportExcel module

$f = Import-Excel -Path "$path" -WorksheetName "Foglio1"

The excel has a SCRIPT column with a custom formula, that references values submitted in the form, something like this:

=CONCAT(H1438,"/",IF(I1438="LOST","LE","AM"),"/",K1438,IF(V1438="Yes",CONCAT("job-",W1438),""))

All rows are imported fine in powershell, except the last one, in which the formula is not parsed. In excel however the last row has all the values submitted and the correct formula.

I tried:

• changing the formula (column “Select a COUNTRY16”), but same behaviour.
• imported the downloaded xlsx file in R with R Studio, same issue on the last row

I also noticed that

• if I open the file in Excel and make any edit on the last row (delete a value and write it back in), when I download it again and import it in Powershell, the last row is parsed correctly.