+ Reply to Thread
Results 1 to 7 of 7

Get notification ( pop up) when some body fills excel

  1. #1
    Registered User
    Join Date
    03-22-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    4

    Get notification ( pop up) when some body fills excel

    Dear All,

    Please help on this.


    Is there any possibility of getting a notification or Pop up to us when some other fills some thing on excel sheet which placed in server ?

    This automatic notification if we can see there on desktop, like we get when we got a new email.

    If its a paid template also no problem. Please help where i can get these type of customization.

    Regards,
    venkati
    Last edited by JBeaucaire; 03-22-2013 at 03:06 AM. Reason: Corrected thread title to topic only

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Get notification ( pop up) when some body fills excel

    Is that file is shared workbook?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    03-22-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Get notification ( pop up) when some body fills excel

    Quote Originally Posted by :) Sixthsense :) View Post
    Is that file is shared workbook?
    yes sir,

    It a shared work book. The idea is if users fills the excel then admins should get a notification automatically once user saved it. There will be many users.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Get notification ( pop up) when some body fills excel

    Until and unless if you DON'T save your open workbook excel will not aware of the new entry, so your file needs some timer to save and check for new entries but user can do entry at any point of time and the timer should also intersect between the user entry time that is the headache here (I believe)

  5. #5
    Registered User
    Join Date
    03-22-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Get notification ( pop up) when some body fills excel

    Quote Originally Posted by :) Sixthsense :) View Post
    Until and unless if you DON'T save your open workbook excel will not aware of the new entry, so your file needs some timer to save and check for new entries but user can do entry at any point of time and the timer should also intersect between the user entry time that is the headache here (I believe)
    We can make it one can enter at a time. For remaining its read only, after one finished the other will enter.

    but after they entering and saving. Is there any way to get the notification automatically at my desktop like outlook email notification ?

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Get notification ( pop up) when some body fills excel

    The headache is not about the restricting the users, eventhough the users have entered the data in a cell and it will get reflected to all when the user and others hit ctrl+s. So just thinking about the timer whether it needs to be set for 10 sec or even less than that to check the newer entry.

  7. #7
    Registered User
    Join Date
    03-22-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Get notification ( pop up) when some body fills excel

    Quote Originally Posted by :) Sixthsense :) View Post
    The headache is not about the restricting the users, eventhough the users have entered the data in a cell and it will get reflected to all when the user and others hit ctrl+s. So just thinking about the timer whether it needs to be set for 10 sec or even less than that to check the newer entry.
    10s is really fine. Even a minute also after saving will work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1