I want the code to run on only one workbook and not on the active workbook.

The problem I am currently having is that pivots must update on "Workbook A" every minute, but when I am working on "Workbook B", excel tries to update those pivots as well, causing it to crash.

Please help as I need a "Live Spreadsheet" ASAP for the company.

Thank You