Excel: 'Unable to set the Calculation property of the Application class'

You need to have an open workbook, ie

import win32com

# Create new Excel instance
xl = win32com.client.DispatchEx("Excel.Application")  

# Open blank workbook
xl.Workbooks.Add()

# Set property
xl.Calculation = win32com.client.constants.xlCalculationManual