Is there a way, without creating a shared workbook, to allow a user who has an file open in Excel 2010 read only mode to see changes just made by another user with the same file open in Excel 2010 edit mode without the read only user closing and
re-opening the file?
F9 seems to only refresh data sources, not the whole sheet.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.