Excel Files Open Twice

[Bagsy Baker]

I have a number of excel files I use constantly at work. Some are opened by themselves and some are part of workspaces. I seem to be getting a repeative error that tries to open the file twice. I'll usually get on of the two following errors.

1.) "A document with the name 'EditDataFiles.xls' is already open. You cannot open two documents with the same name, even if they are in different folders. To open a second document, either close the document that's currently open, or rename one of the documents."

or

2.) "Matching Grilles.xls is already open. Reopening will cause any changes you make to be discarded. Do you wannt to reopen Matching Grilles.xls?"


Normally this is not a problem, but I do have a few files that open, do a task, save to another file, and close without operator intervention. What ends up happening is the information is transfered twice to the save file. Since this file is used quaterly to forecast future demand, duplicate data causes all the information to be useless. The files are run on a Windows 98, Second Edition with Excel 97. The files are local and not accessable through the network.

Any help would be appreciated.

 

[starl]

you've got code attached?
is this happening to all files?
files only in a certain location?

 

[zacemmel]

Start - > Run - > Excel /unregserver

Start - > Run - > Excel /regserver

 

[JLouis]

Can someone expand on this issue.

I am using Excel97 and have a file Command Center that gets the same error as described above.

The start-run advice did not work.

Any suggestions?