How to synchronize Excel Sheet over Network

[AmrMahmoud1982]

anyone know How to synchronize Excel Sheet over Network

ok



the story is , i have a shared Excel File on file server
me and my friends all access it

of course when someone open it first , he can do everything
and i only can open it as " read only "

what i wish is :
when i open this excel sheet as read only , then i make my changes in it
i wish those changes update the file , when it's available for editing
or when he close it

[Kimberly]

This isn't exactly what you requested, but probably accomplishes the same goal:
On the Review tab, click 'Share Workbook'
On the Editing tab, check this box: 'Allow changes by more than one user at the same time. This also allows workbook merging'
On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK

You won't be able to add or change the following: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, workbook and worksheet protection, and macros.