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

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
>

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

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
>>>
>>
>>
>>
>

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
>>>>
>>>
>>>
>>>
>>

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

Hi Kim,

To display the formula bar, go to Tools > Options> View > and check the box
next to "formula bar".

A toolbar will appear in the head.

Click on the cell with the date in it, and in the formula bar (the textfield
right next to where it say's "fx") it will show what Excel sees in that
cell.
If it just shows the date, just like it reads in the cell, it's something
else.
However, if it shows a formula starting with "=", there's the problem.
If it's doing that, just copy the code out of the formula bar and paste in
in the reply.

To see exactly what I mean, in an empty cell type:
=2+2

After you hit enter, it will say 4 in the cell but the formula bar will
read:
=2+2

I know Excel very well.
I'd be happy to you. I'll reply off list.

Take care,
Tim


"kim" <kim@removegeekministry.com> wrote in message
news:g33gal$aue$1@forums.macromedia.com...
> 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
>

> 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

It sounds like you have a forumula/script in that cell that's being told to
grab the current date.

That would be opposed to it just being a text field with a typed in date.

-Darrel

That's exactly what it was.

=(today)

Take care,
Tim


"darrel" <notreal@nowhere.com> wrote in message
news:g3686f$dmj$1@forums.macromedia.com...
>> 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
>
> It sounds like you have a forumula/script in that cell that's being told
> to grab the current date.
>
> That would be opposed to it just being a text field with a typed in date.
>
> -Darrel
>

I believe you

TC2112 skrev:
> That's exactly what it was.
>
> =(today)
>
> Take care,
> Tim
>
>
> "darrel" <notreal@nowhere.com> wrote in message
> news:g3686f$dmj$1@forums.macromedia.com...
>>> 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
>> It sounds like you have a forumula/script in that cell that's being told
>> to grab the current date.
>>
>> That would be opposed to it just being a text field with a typed in date.
>>
>> -Darrel
>>
>
>
>

--
Kim
---------------------------
http://www.geekministry.com

ok i will put it up and give the link soon cheers !