Recorded Macro Does Not Work

**TheColorLavender** · 05-29-2012, 05:02 PM

Hi, I recorded a macro, but it always gets stuck at the command shown in red:

Please Login or Register  to view this content.

Please let me know as to how I can fix this (attached is the entire macro, I highlighted the command that does not work, which is the first command on page 5). Thank you!

**Medpack** · 05-29-2012, 06:06 PM

Nevermind, looked at your attached file - can you attach your actual workbook, rather than just the code itself? More than likely Pivot Field "Division" doesn't exist under Pivot Table "PivotTable32" or PivotTable32 is on a different sheet than PivotTable1. (e.g. not the activesheet). Try replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

.

**TheColorLavender** · 05-30-2012, 09:40 AM

Hi MedPack, I tried to attach the workbook, but I guess the file size was too big (over 6MB), so the upload was not successful. The file contains 6 pivot tables on the same sheet, and the objective of the macro is to change the criteria of "Division" and "Bus Type" in each pivot table. The macro works for the first pivot table, but then gets stuck when it comes to the 2nd one. Let me know if I can send the attachment to your personal email if you still need to see the actual workbook.

Thank you for looking into this for me!

**sarails** · 06-05-2012, 01:56 AM

I hope that you have fixed yoru problem, but it sounds as if your changes are causing the Pivot tables to overlap each other which causes an error, but one that the code generally cannot show whilst in "step through" mode.

Try giving your pivot tables more room on the sheet, or move them to seperate sheets and then address them like medpack has suggested.

hope this helps.

Iain