How can I update a shared workbook in Excel
Posted on 2003-03-21
Hi all, Some coworkers and I use an Excel Spreadsheet to track our work progress. We have it shared on a network drive and it is set so we can all be in it at once.
What we would like, is some way to refresh the data so we see the other saved changes without closing and reopening the spreadsheet.
Is there a way to do this built into Excel? Or is there a macro of some sort we could use to do this?