Hi Tim,
> The Assist thing in word that prompts today's date and format is
> AutoCorrect.
That's it.
> 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?
No.
>
> If you select the cell with the date that changed to today's, and look in
> the formula bar..what does it say?
Where do I find the formula bar? (I'm using Office 2003) but if I click
data > formula I get a box that says (it's Danish) DATO:: 16-06-2008
(which is the format I want for dates.
> If it is just the date, what format is it?
See above.
>
> In Excel, Tools > AutoCorrect > Smart Tags
> Are smart tags embedded?
Hmmm... I don't think that is something available in Office 2003
Anyway if I open any doc and close it again without doing anything with
the file other than open it I get asked if I want to save my work!
BTW... are you good at excel? I need to have an invoice created with the
right functions in place. If you're interested please contact me off list.
Thanks a lot
Kim
>
>
> 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
>>>>>
>>>>
>>>>
>
>
>
--
Kim
---------------------------
http://www.geekministry.com