Hello,
I don't think that's it.
AutoComplete is the function that scans the column for values you have
already entered.
If it finds something you already entered that is similar to what you are
now typing, it prompts you so that if it is the same value, you can just hit
enter.
For example, you have a column of fruits: Apple, Orange, etc.
If Apple already exists in the column, and you start typing "A p p" it it
will autofill Apple for you.
If that is right, hit enter. If not, keep typing.
If you have never entered Apple in the column before, it won't prompt at
all.
This can be a huge time saver if the value you keep adding to this column is
one that you've entered before.
Specially if the value is a really long word :-)
The Assist thing in word that prompts today's date and format is
AutoCorrect.
There's something more to this. A couple things to check.
When you open this excel file, does it give an "update links?" dialog box?
If you select the cell with the date that changed to today's, and look in
the formula bar..what does it say?
If it is just the date, what format is it?
In Excel, Tools > AutoCorrect > Smart Tags
Are smart tags embedded?
Take care,
Tim
"Virginia Carter" <vcarter@carolinawebcreations.biz> wrote in message
news:g333mn$r4o$1@forums.macromedia.com...
> You can turn off auto cell completion with this:
>
> Tools > Options > Edit Tab and then clear the Enable AutoComplete for
> cells option.
>
> --
>
> Virginia Carter
> Carolina Web Creations
> ======================
> www.carolinawebcreations.biz
>
> kim wrote:
>> Hi Tim,
>>
>> No. It's all dates in any .xls or .doc. I guess it has to do with the
>> "assistant" that offers to finish the date and I use to press enter when
>> this option occurs.
>>
>> What happens is this. I type a date in a spreadsheet (no macros or
>> anything like that... just a date lets say when the xls/doc was created)
>> or in a word document and save my file.
>>
>> If I then open this document/spreadsheet a month later the dates has
>> changed to today's date... which is very inconvenient since I've no idea
>> when the file was created! (well maybe there is an option when I can see
>> this and then manually chage the date in the document... but I rather
>> have the date didn't changed in the first place)
>>
>> Hope this made some sense
>>
>> Thanks
>>
>> TC2112 skrev:
>>> Hi Kim,
>>>
>>> What date changes? Is it a specific cell in a worksheet, dates in a
>>> range or all dates?
>>> Did you create this workbook? If so, are there any macros, formulas or
>>> conditional formatting attached to the date that changes?
>>>
>>> If it is a date in a cell(s) somewhere, and you can easily remove any
>>> private data I'd be happy to take a look at it.
>>> Just put it up and give the link.
>>>
>>> Take care,
>>> Tim
>>>
>>>
>>> "kim" <kim@removegeekministry.com> wrote in message
>>> news:g32kdi$cdo$1@forums.macromedia.com...
>>>> Hi,
>>>>
>>>> I'm sorry for this OT question... but I know someone knows what I need
>>>> to do.
>>>>
>>>> My problem is that whenever I open an excel file created 6-8 month ago
>>>> it changes the date to current date... and I DON*T WANT THAT. WTF was
>>>> you thinking MS
>>>>
>>>> Anyway... is there a way I can turn this of?
>>>>
>>>> --
>>>> Kim
>>>> ---------------------------
>>>> http://www.geekministry.com
>>>>
>>>
>>>
>>>
>>