Hello, everyone.

I'm new to the forum - Hello! - and quite new to the more 'intermediate' functions of Excel. I have a problem...

I have created workbook "Overview", it is connected to another workbook, it's pulling data from a log that several users use. I want the Overview to summarise the data that is in the log. All of the formulae work in the Overview, it's just not updating automatically! Would there be a particular reason why it wouldn't be working?

The only way I can get it to update is by: Data Tab > Connections Group > Edit Links > Update Values. I'd prefer it if it was real time, is this possible?

Capture.PNG

Kristian