VBA to create PivotTables suddenly not working -worked this morning but not this afternoon.

Occasional Visitor

Today - I was running VBA that creates Pivot Tables and reports from them.  I have been using the same code for over 6 years and this afternoon, my VBA would not process anything dealing with creation of Pivot Tables and Pivot Caches - I got inconsistent run-time errors.  My excel has been real buggy lately.  I have reinstalled Office 365 3 times this week and even had Microsoft Support trying to figure out what is going wrong.  I spent almost 2 hours with them and we couldn't get any resolution.  These same reports are run on several different computers.  It's just mine that is having issues.  Excel has crashed several times during the last 2 weeks.  I run diagnostics and everything is fine  Any ideas?

0 Replies