Random changes in date column

Microsoft Office 2007 small business wit...
March 1, 2011 at 12:26:13
Specs: Windows XP Prof. SP 3, 3.0 gb RAM;
The workbook is a log of video clips from a granny cam. It spans a period of approx 3 weeks, there is a row for each clip - a total of approximately 1900 clips. There are columns for date, time, clip no., length, and notes on the clips. Our problem is the date column is arbitrarily changing random dates. They are easy to spot b/c of the time column, since the videos were motion activated that dates would obviously change at 12:01 am. The problem for ex.will be a date or several dates of 8/16/08 mixed in with 8/15/08, and it progresses that way throughout all the rows in the workbook with no discernable pattern. The workbook also updates the dates with daylight savings time changes. (I would like to stop that as well).

See More: Random changes in date column

Report •


#1
March 2, 2011 at 07:42:15
Are you the creator of this spreadsheet?
If not I would speak to the person who created it and ask that they modify it to suit your needs.

Sounds like you might have several macros running, if it auto updates.

MIKE

http://www.skeptic.com/


Report •

#2
March 2, 2011 at 14:03:17
I am the author. I don't know about macros causing an auto update. Could be though. I decided to first do the following: " Microsoft Office Button, and then Excel Options, Formulas tab, Manual under Calculation options" I'll wait a couple of days to see if it auto updates. I probably should have done that before posting, but I just didn't think of it. Thanks for replying.

Report •

#3
March 2, 2011 at 14:15:53
Are the entries in the cells hyperlinks perhaps?

Did you use the =TODAY() or =NOW() functions?


MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question