Export-Excel -Clearsheet fails to clear the worksheet of processed new users. It worked when I first used it, but now it returns an error stating it can't find the sheet. I hope I'm just missing a new step between extracting data from the sheet and trying to update it.
New User.xlsx NOTE: Actual file is .xlsm, in case that makes a difference.
Export-Excel -Clearsheet fails to clear the worksheet of processed new users. It worked when I first used it, but now it returns an error stating it can't find the sheet. I hope I'm just missing a new step between extracting data from the sheet and trying to update it.
New User.xlsx NOTE: Actual file is .xlsm, in case that makes a difference.
ExcelScript.txt