My macro below updates all of the data connections in a workbook, and updates the references to the workbook in the actively running powerpoint show. Using OnTime, it runs the code every minute.

After running for awhile, it appears as if the computer gets bogged down, and I get some errors. Different errors include: maximum number of threads reached, linked files not available, and out-of-memory.

Is there any way I can optimize the code to not use as much memory? Is there something else I can do to improve the code?

Thanks!

Please Login or Register  to view this content.