#1   Report Post  
RG at UW
 
Posts: n/a
Default Update Field

I would like to add a date field that would only change if the spreadsheet is
updated, not just opened.

Thanks

  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

RG

"Updated" means what?

Calculated or.....?

I think you want a Time Stamp that will change when a cell is changed but not
be volatile otherwise.

See JE McGimpsey's site for code.

http://www.mcgimpsey.com/excel/timestamp.html


Gord Dibben Excel MVP

On Mon, 2 May 2005 14:31:08 -0700, "RG at UW" <RG at
wrote:

I would like to add a date field that would only change if the spreadsheet is
updated, not just opened.

Thanks


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
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 27th 05 11:25 PM
Auto Update / Save Chewy Excel Discussion (Misc queries) 1 February 15th 05 10:09 PM
Pivot Table Page Field Jimbola Excel Discussion (Misc queries) 0 February 6th 05 09:13 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 12:18 AM


All times are GMT +1. The time now is 02:57 PM.

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

About Us

"It's about Microsoft Excel"