excel97, =today() and windows XP

[JMS]

Does anybody have sollution for following problem?

I have excel97 and window XP installed. When I use =today() function on worksheet, it shows "today" correcty. But when I try to open saved worksheet, excel gives following warning:

" File.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen File.xls?
Yes No "

In windows98 same excelsheet worked. Also if I don't use =today()-function no problem.

/ JMS

 

[Anne Troy]

Yep. You've got a bizaare one.

Are you saying that if you create a brand new file in Excel and type =today() in a cell that you're unable to save that file?

Or does this happen only in one file?

Also, =today() is more commonly used in Access, I believe. In Excel, it's generally =now()

 

[JMS]

Problem occours when I try to open just saved file. No problems reported when I save file.

I can repeate problem with all worksheets having =now() or =today() function.

/JMS

 

[Anne Troy]

Okay, so after you close a file--and have NO files in Excel open, but Excel is still running, hit ctrl-alt-del. In the task list, you should see Excel, but you should NOT see a file name behind it. Is there a file name behind it, such as:

Microsoft Excel - filename.xls

 

[JMS]

Problem solved!

Reason was confifuration for .xls file assosiation...

In Tools/Folder Options
--> File Types
--> XLS
--> Advanced
--> Open
--> Edit
--> Use DDE / DDE Message, conatained something like [open("%1")]

... which probably confused program, because Aplication path already contained %1

Windows XP propably noticed this because on instead of Advanced, it said Restore for extension. And after "restore" and removing [open("%1")] file opens OK.


/ JMS