[Anthony[_3_]]

Hi All,

I am wondering if anyone has a solution on this.

There is a Word 2007 file (docx) that has links to an Excel file.
They are both resided in the same folder. When the files are moved to
another folder, the link path does not get updated – which I
understand. But when the Word file is first opened, the following
message came up:

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

(Notice that it does not matter if the source file is xlsm or xlsx.)

This message would come up for every links in the file. One has to
keep clicking the [Ok] button to by pass this. If there are 100 links
in the file, one would have to click 100 times. Unfortunately, there
are over 100 files like that and some may contains hundreds of
links.

(Also, when the Word docx is opened, Excel also came up in the
background - as shown in the Windows Task Manager.)

The problem would occur whether the Excel source file is opened or
not. When I save the 2007 docx file into 2003 doc file, there is no
such problem for the 2003 doc file.

You may replicate the error following the simple steps below:
1. Create a link from an Excel xlsx or xlsm file (say in cell A1) into
a Word 2007 docx (using paste special.. with the link button checked)
and save both files in “Folder 1”.
2. Copy the folder with the two files and rename the folder to “Folder
2”.
3. Open the Word file from folder 2.

When you have done all these you will encounter the error.

Could anyone help?

Anthony

[Twayne[_2_]]

In ,
Anthony typed:
Hi All,

I am wondering if anyone has a solution on this.

There is a Word 2007 file (docx) that has links to an Excel file.
They are both resided in the same folder. When the files are moved to
another folder, the link path does not get updated – which I
understand. But when the Word file is first opened, the following
message came up:

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

(Notice that it does not matter if the source file is xlsm or xlsx.)

This message would come up for every links in the file. One has to
keep clicking the [Ok] button to by pass this. If there are 100 links
in the file, one would have to click 100 times. Unfortunately, there
are over 100 files like that and some may contains hundreds of
links.

(Also, when the Word docx is opened, Excel also came up in the
background - as shown in the Windows Task Manager.)

The problem would occur whether the Excel source file is opened or
not. When I save the 2007 docx file into 2003 doc file, there is no
such problem for the 2003 doc file.

You may replicate the error following the simple steps below:
1. Create a link from an Excel xlsx or xlsm file (say in cell A1) into
a Word 2007 docx (using paste special.. with the link button checked)
and save both files in “Folder 1”.
2. Copy the folder with the two files and rename the folder to “Folder
2”.
3. Open the Word file from folder 2.

When you have done all these you will encounter the error.

Could anyone help?

Anthony

Seems pretty clear to me; the two documents simply cannot have the same name
if they need to be opened at the same time: Change one of the names. Add a
space, underscore, dash, whatever to one of them and not the other or change
the actual name altogether.

HTH,

Twayne




--
--
Life is the only real counselor; wisdom unfiltered
through personal experience does not become a
part of the moral tissue.

[Twayne[_2_]]

In ,
Anthony typed:
Hi All,

I am wondering if anyone has a solution on this.

There is a Word 2007 file (docx) that has links to an Excel file.
They are both resided in the same folder. When the files are moved to
another folder, the link path does not get updated – which I
understand. But when the Word file is first opened, the following
message came up:

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

(Notice that it does not matter if the source file is xlsm or xlsx.)

This message would come up for every links in the file. One has to
keep clicking the [Ok] button to by pass this. If there are 100 links
in the file, one would have to click 100 times. Unfortunately, there
are over 100 files like that and some may contains hundreds of
links.

(Also, when the Word docx is opened, Excel also came up in the
background - as shown in the Windows Task Manager.)

The problem would occur whether the Excel source file is opened or
not. When I save the 2007 docx file into 2003 doc file, there is no
such problem for the 2003 doc file.

You may replicate the error following the simple steps below:
1. Create a link from an Excel xlsx or xlsm file (say in cell A1) into
a Word 2007 docx (using paste special.. with the link button checked)
and save both files in “Folder 1”.
2. Copy the folder with the two files and rename the folder to “Folder
2”.
3. Open the Word file from folder 2.

When you have done all these you will encounter the error.

Could anyone help?

Anthony

Seems pretty clear to me; the two documents simply cannot have the same name
if they need to be opened at the same time: Change one of the names. Add a
space, underscore, dash, whatever to one of them and not the other or change
the actual name altogether.

HTH,

Twayne




--
--
Life is the only real counselor; wisdom unfiltered
through personal experience does not become a
part of the moral tissue.