Xl Crashing: Code to format after Pivot: Show Report Filter Pages.

Hello friends! Hope all is well,

The attachment here has a sheet, that is reflected on a pivot table. The PT is then brokendown to "Show Report Filter Pages" on multi sheets.

The Excel workbook is crashing, please help me fix the crashing.

thank you very much!

When does it "crash"? I opened it ok.

thank you very much for the reply. Yes the codes do go smoothly. but after all was run, and I select any sheet, it crashes. thanks

Maybe describe your actual steps. I don't know which code you run.

ok, basically. The:
1. Sheet DB feeds the PT
2. The code then breaks the DB contents to sheets based on column A of DB (Show Report Filter Pages).
3. Then replace the pivot tables of each sheet with data, i.e. copy and paste values. to show data that was created via Pivot Tables.
4. And then apply formatting and column widths of all sheets at one go.

I mean like this.

Step 1 - Open the workbook
Step 2 - Click on sheet XYZ
Step 3 - Click on button ABC
etc.
Step 8 - Workbook crashes

after carefully checking and reviewing, it worked! thanks to all of you.