<div>
When you share the workbook using<br />
Tools/Share Workbook...<br />
Click on the Advanced tab at top<br />
Select Update Changes Automatically<br />
Enter the time interval in minutes<br />
<br />
gasmole
</div>


When you share the workbook using
Tools/Share Workbook...
Click on the Advanced tab at top
Select Update Changes Automatically
Enter the time interval in minutes

gasmole

<div>
<div class="content wysiwyg-content">
Hi all, Some coworkers and I use an Excel Spreadsheet to track our work progress. &nbsp;We have it shared on a network drive and it is set so we can all be in it at once.<br />
What we would like, is some way to refresh the data so we see the other saved changes without closing and reopening the spreadsheet.<br />
<br />
Is there a way to do this built into Excel? Or is there a macro of some sort we could use to do this?<br />
<br />
Thanks
</div>
</div>


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?

Thanks

How can I update a shared workbook in Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.