After doing some addition sleuthing I was able to isolate the problem to the conditional formatting in the table. When the table gets copied, revised, and then pasted back into its original location the conditional formatting gets added to the previous formatting so that every time the macro is ran the conditional formatting list for each cell gets progressively longer. When I deleted the formatting the macro blazed through every time. Is there a way to keep the formatting from duplicating?
Bookmarks