MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot tables in Excel/macros

Posted by Cat on August 23, 2001 7:00 AM

I would like to record a macro that will create a pivot table for weekly data that I have to compile. What I've found is the pivot table always refers back to the spreadsheet that I recorded the macro on, instead of the new spreadsheet on the following week. I've tried recording using the relative command but no luck. Any ideas?

Posted by Colm on August 23, 2001 7:11 AM


Hi Cat,

When you go to tools record new macro it will ask you to record Macro in(This workbook,new workbook or personal Macro workbook)
Choose personal Macro workbook and then when you record the Macro you should be able to use it with any spreadsheet.

Hope this helps