Macro is running real slow and makes navigating the worksheet really slow after execution.

Hi Guys,

This is my first post.

I am running a fairly simple macro. At a high level this macro filters a report on a separate worksheet("Extract") and copies the names in column A into another worksheet ("Individual Snapshot"). Then I put a few offset formulas next to column A to extract other data points from the Extract worksheet. then create pie graphs in column L.

This surprisingly takes really long and after it executes it is really slow to navigate around the "Individual Snapshot" worksheet.

BUT, if I close out of the workbook and open it I am able to navigate the "Individual Snapshot" worksheet.

Any advice??