Excel Macro is Broken after Upgrade to 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1537186%22%20slang%3D%22en-US%22%3EExcel%20Macro%20is%20Broken%20after%20Upgrade%20to%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537186%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EMy%20Excel%20macro%20no%20longer%20runs%20after%20I%20upgraded%20to%20Office%20365.%20I%20am%20getting%20an%20Run-time%20error%20'1004'%3A%26nbsp%3B%20Unable%20to%20get%20the%20PivotFields%20property%20of%20the%20PivotTable%20class%20error.%26nbsp%3B%20The%20macro%20worked%20fine%20last%20week%20before%20I%20upgraded%20from%20Office%202016.%26nbsp%3B%20Any%20suggestions%20on%20what%20is%20causing%20the%20problem%20would%20be%20helpful.%26nbsp%3B%20Thanks%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1537186%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

My Excel macro no longer runs after I upgraded to Office 365. I am getting an Run-time error '1004':  Unable to get the PivotFields property of the PivotTable class error.  The macro worked fine last week before I upgraded from Office 2016.  Any suggestions on what is causing the problem would be helpful.  Thanks in advance. 

0 Replies