Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

Microsoft Excel doubts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lk.kumaresan@gmail.com - 18 Mar 2008 12:04 GMT
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
Bob I - 18 Mar 2008 14:45 GMT
It's not a feature of Excel, perhaps you may search on google for this
file monitoring/ notification system.

> we have uploaded some excel files in shared folder of file-print
> server, some users have read only permission, some have write and some
[quoted text clipped - 11 lines]
> regards,
> L.Kumaresan
JP - 18 Mar 2008 14:58 GMT
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 Tools>Options>General and typing in the "user name".

HTH,
JP

On Mar 18, 7:04 am, lk.kumare...@gmail.com 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
[quoted text clipped - 11 lines]
> regards,
> L.Kumaresan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.