Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel doubts
we have uploaded some excel files in shared folder of file-print
server, some users have read only permission, some have write and some have full permission in a group. my question is If one user modifies the file, all the other user of that group should get some alert or popup to intimate that the file is modified by such user. please help me. Is is possible? should I have to purchase any third party software? If I have to purchase third party software then the details of such vendor. thankyou. regards, L.Kumaresan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel doubts
It's not a feature of Excel, perhaps you may search on google for this
file monitoring/ notification system. wrote: we have uploaded some excel files in shared folder of file-print server, some users have read only permission, some have write and some have full permission in a group. my question is If one user modifies the file, all the other user of that group should get some alert or popup to intimate that the file is modified by such user. please help me. Is is possible? should I have to purchase any third party software? If I have to purchase third party software then the details of such vendor. thankyou. regards, L.Kumaresan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel doubts
It's complicated, but you could create some event code that, when
someone makes a change to the file, it uses Outlook to send an email (ideally, after they hit 'Save' and are exiting the worksheet, to minimize disruption). However there is no way to do this silently. Note that if you share the workbook, when someone hits 'Save' then the other users that currently have the workbook open do get a popup notification that 'someone' changed the file (doesn't say who, though). You could scan the file and the changed cells are (temporarily) commented. A shared workbook also generates a history worksheet showing the changes and who made them. Keep in mind everyone has to update the user name in their copies of Excel by going to ToolsOptionsGeneral and typing in the "user name". HTH, JP On Mar 18, 7:04*am, wrote: we have uploaded some excel files in shared folder of file-print server, some users have read only permission, some have write and some have full permission in a group. my question is If one user modifies the file, all the other user of that group should get some alert or popup to intimate that the file is modified by such user. please help me. Is is possible? should I have to purchase any third party software? If I have to purchase third party software then the details of such vendor. thankyou. regards, L.Kumaresan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two doubts for Macros | Excel Discussion (Misc queries) | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
I have doubts about Create Lines Charts | Charts and Charting in Excel | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) |