数据透视表创建经常失败

请问技术大佬们，流程步骤里面新建数据透视表，偶尔出现失败是什么情况，有什么方法避免么？

 (-2147352567, '发生意外。', (0, None, None, None, 0, -2147024809), None)
Traceback (most recent call last):
File "<string>", line 338, in create_pivot_table
File "<COMObject PivotFields>", line 2, in Item
pywintypes.com_error: (-2147352567, '发生意外。', (0, None, None, None, 0, -2147024809), None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.3.27\python\lib\runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.3.27\python\lib\runpy.py", line 85, in _run_code
exec(code, run_globals)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.3.27\python\lib\site-packages\xbot_interpreter.py", line 67, in <module>
main()
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.3.27\python\lib\site-packages\xbot_interpreter.py", line 45, in main
try:
File "C:\Users\bc\AppData\Local\ShadowBot\users\74520cff-d771-4b10-8f7d-7b9d49e83d31\apps\29bedf0f-2407-4346-bd15-8cfac08300b8\xbot_robot\main.py", line 508, in main
xbot_visual.excel.create_pivot_table(workbook=excel_instance3, setting="{\"sourceType\":1,\"sheetName\":\"Sheet6\",\"tableRange\":\"A3:B688\",\"name\":\"数据透视表1\",\"properties\":[{\"name\":\"ColumnGrand\",\"value\":true},{\"name\":\"RowGrand\",\"value\":true},{\"name\":\"SubtotalHiddenPageItems\",\"value\":false},{\"name\":\"InGridDropZones\",\"value\":false},{\"name\":\"LayoutRowDefault\",\"value\":0},{\"name\":\"DisplayFieldCaptions\",\"value\":true},{\"name\":\"ShowDrillIndicators\",\"value\":true},{\"name\":\"DisplayContextTooltips\",\"value\":true},{\"name\":\"SortUsingCustomLists\",\"value\":true},{\"name\":\"DisplayImmediateItems\",\"value\":false},{\"name\":\"FieldListSortAscending\",\"value\":false},{\"name\":\"ShowValuesRow\",\"value\":false}],\"fields\":[{\"name\":\"BC1654496340\",\"index\":\"1\",\"formula\":null,\"customName\":\"BC1654496340\",\"subtotals\":[true,false,false,false,false,false,fals