Excel 2003: can anyone tell me how to show changes to a shared worksheet automatically each time a user enters data? A refresh button would be second-best. With Shared workbook\Advanced I can get 5 minute updates but how can I get 1 minute> TIA Steve