real time

I have a variable Y Y = RANDBETWEEN(2,15) And a variable X X = NOW() I am using the following VBA code to refresh the date; to simulate a real time data flow: Sub Calculate_range() Range("A1:A7").Calculate Application.OnTime DateAdd("s", 2, Now), "Calculate_range"...

I am starting a project with excel, access, etc. I want to know if this is possible through excel: One main spreadsheet with different sheets having multiple users accessing the file and it updating in real time. -Or- Multiple spreadsheets for each user and each can read from each other...

I currently have an access database that is linked to a another data source and they mirror each other. I have spread sheets that access this information and i was curious if it's possible to have the Access Data source updated/refreshed "Real Time". I normally had to generate the list by...