79160283

Date: 2024-11-05 18:28:03
Score: 1.5
Natty:
Report link

try:

$excel = New-object -ComObject excel.application
$workbook = $excel.WorkBooks.Open("filepath")
$Workbook.Parent.Calculation = -4135
...
...
#Turn recalculate back on
$Workbook.Parent.Calculation = 1

This works if you have Excel installed

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Jeffrey L Prochaska