excel97, =today() and windows XP

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

JMS

Thread Starter
Joined
Dec 3, 2001
Messages
3
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

Anne
Joined
Feb 14, 1999
Messages
11,749
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

Thread Starter
Joined
Dec 3, 2001
Messages
3
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

Anne
Joined
Feb 14, 1999
Messages
11,749
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

Thread Starter
Joined
Dec 3, 2001
Messages
3
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top