Hello,
I have a workbook which is updated as a log by several staff members continuously throughout the day. Another workbook has Pivot Tables that run off data imported from the other (shared) workbook. Problem is, whenever someone wants to open it up and look at the Pivot Tables, the source workbook becomes 'locked for editing' until they leave.

How can you import data without 'locking' the external source?

I would have thought this was a common problem but i can't find any solutions after searching... any ideas?

Appreciate any help.