Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default problem with auto update of date and time

Our office has got around 50 pcs connected to each other thro intranet. As an
administrator, I have incorporated auto update function for date and time (to
have a record of last saved details) for all excel sheets..File Modification
rights is given to all users.

The problem is :
a) The auto update functions works satisfactorily for a few user login
but is not working in a few.
b) The file gets saved, but date and time is not getting updated.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default problem with auto update of date and time

How have you implemented this auto update function?

Through VBA code? Where does the code reside?


Gord Dibben MS Excel MVP

On Wed, 25 Jun 2008 22:06:10 -0700, saran
wrote:

Our office has got around 50 pcs connected to each other thro intranet. As an
administrator, I have incorporated auto update function for date and time (to
have a record of last saved details) for all excel sheets..File Modification
rights is given to all users.

The problem is :
a) The auto update functions works satisfactorily for a few user login
but is not working in a few.
b) The file gets saved, but date and time is not getting updated.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto update of date and time whenever changes are made to a xcel s saran Excel Worksheet Functions 2 June 24th 08 01:39 AM
auto update of date and time whenever changes are made to a xcel s saran Excel Worksheet Functions 9 June 23rd 08 02:44 PM
auto update of date gibbs Excel Worksheet Functions 1 February 23rd 08 02:24 AM
Auto update daily report problem SteveG Excel Discussion (Misc queries) 4 February 9th 06 08:25 PM
Auto Update after certain time period (60 sec) mrdelia New Users to Excel 5 July 10th 05 05:06 PM


All times are GMT +1. The time now is 06:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"