Hi,

I have 2 spreadsheets, one of which is to be displayed on a monitor at all
times for informational purposes. The other spreadsheet is an export file
from microsoft access.

The spreadsheet being displayed contains data linked to the export file. I
can't seem to get the display spreadsheet to auto update itself after a
specific period of time. The spreadsheet will only update whenever the export
file is opened.

Is there a way to auto update/refresh the display spreadsheet (always open),
linked to the exported spreadsheet file (always closed), without having to
open and close the exported spreadsheet file?

The exported spreadsheet file is updated frequently via microsoft access.

Thanks in advance.