I'm having very similar issues trying to automate in VBA (Office 2010, not SP1, installed around April this year, so that's my first thing to try).
In my case I run a macro on Workbook.Open that updates all pivots, then on Workbook.Close saves the workbook as an .xlsm to a temp folder, then...