Excel Files Open Twice

Bagsy Baker

New Member
Joined
Feb 17, 2002
Messages
39
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.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

starl

Administrator
Joined
Aug 16, 2002
Messages
5,959
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
you've got code attached?
is this happening to all files?
files only in a certain location?
 

zacemmel

Well-known Member
Joined
Apr 29, 2002
Messages
636
Start - > Run - > Excel /unregserver

Start - > Run - > Excel /regserver
 

JLouis

Board Regular
Joined
Jan 1, 2004
Messages
165
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,169
Messages
5,570,654
Members
412,335
Latest member
cinciri99
Top