#1
|
|||
|
|||
How to synchronize Excel Sheet over Network
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 |
#2
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access to an Office 2010 Excel file over network | lohith.korp | Office | 2 | 09-27-2010 08:32 AM |
Excel slow when connected with network and switching off server | viswaforu | Excel | 0 | 07-06-2010 09:30 PM |
Any tutorial same as to this excel sheet with code? | Learner7 | Excel | 1 | 05-18-2010 05:31 PM |
Excel sheet Sequence Number | belloffice | Excel | 1 | 02-25-2010 02:41 PM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |