Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How can I update a shared workbook in Excel

Posted on 2003-03-21
Medium Priority
Last Modified: 2012-06-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?

Question by:Zakoriz

Expert Comment

ID: 8183639
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

LVL 81

Accepted Solution

byundt earned 80 total points
ID: 8185011
The Tools...Track Changes...Highlight changes option will both share the workbook and highlight the changes that any of your colleagues make.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question