Hello, I'm new to the forum.
I have an excel workbook on a dedicated PC that retrieves data from production equipment in near real time. I have created a workbook on our plant server that references this data. I want to be able to get the latest data to anyone who opens this workbook. Currently, the data is only updated when the primary workbook is saved by the main PC. I need to be able to program it to save the file every 15 seconds, or find a way to link the other workbook to the open one so the data is updated constantly.

Thanks in advance
Paul C.