Greetings all

I need help with the following, I have two workbooks, one of them is used as a Database, where only one user at the time can enter or modify data, this document is placed in a network computer, the other document is a workbook with a user interface to consult only, users can not write or edit the second workbook, so far I could connect both workbooks, but the second workbook does not update in real time.

Is there a way I can use to make the second workbook update in real time or at least in short time periods without having to close and open the workbook?

I am using excel 2010

Thanks in advance.