I have an Excel Workbook that is Shared on a common network. If I have it open and another person opens the workbook and makes a change, I do not automatically see the change on my open workbook. Do I need to refresh (is that possible??) my Excel sheet? I do not want to close my open workbook and re-open every time I want to see all the changes.
You should get the updates automatically when the file is saved - at least this is the default behavior on Excel 2010, but, as Microsoft states in Use a shared workbook to collaborate (http://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HP010342985.aspx):
Meetings to discuss business process can waste time, and often do . The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds. A jointly-developed process picture helps wade through the confu…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents.
Select the "Insert" tab:
Type "http://" followed by a web address to reference a website or navigate to a document to ref…