1. R

    2003 Macro to 2010 - Error Code 5 in PivotCaches.Add

    I have a 2003 Excel xls file that I am trying to run in Excel 2010. I first saved the file as a xlsm and added the directory as trusted in Trust Center. I am getting an error code in the red. Note: If I change the PivotTableVersion to 12, it still gives me the same error. Code is below. Thank...
  2. J

    1004 problem with ActiveWorkbook.PivotCaches.Add

    I am trying to build a macro to be placed in a blank spreadsheet for use as a template. My development platform is Excel 2003 on Windows XP SP2. The script was initially recorded as a macro against a single data file with absolute range references and worked both on my develpment platform and on...

Some videos you may like

This Week's Hot Topics