[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

[macropod[_2_]]

Hi Anthony,

See reply in microsoft.public.word.vba.general.

Please don't post the same question multiple times in different newsgroups - you can post to multiple newsgroups simultaneously, if
need be, so that an answer in one newsgroup propagates to all.

--
Cheers
macropod
[Microsoft MVP - Word]


"Anthony" wrote in message ...
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

[Anthony[_3_]]

Hi Macropod,

I understand. I will delete all the other post that no one has
answered. Please do that same if you want, because I just found out
that only the creator of the post (not the creator of the thread) can
delete their own post.

Anthony

[Doug Robbins - Word MVP]

You cannot delete them. What you could do is post a message in response to
them advising that the thread is being continued in the vba.general group so
that anybody who is interested in the subject should go to that group.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Anthony" wrote in message
...
Hi Macropod,

I understand. I will delete all the other post that no one has
answered. Please do that same if you want, because I just found out
that only the creator of the post (not the creator of the thread) can
delete their own post.

Anthony

[Anthony[_3_]]

On Feb 22, 3:33*am, "Doug Robbins - Word MVP"
wrote:
You cannot delete them. *What you could do is post a message in response to
them advising that the thread is being continued in the vba.general group so
that anybody who is interested in the subject should go to that group.

Hi Doug,

I did delete the ones that no one answered. Once there is post from
someone, then I cannot delete those posts - I can only delete my own
post.

Everyone, this thread is being continued at:
http://groups.google.com/group/micro...00e2929f496e27

Anrthony

[Terry Farrell]

Be assured that it only deleted your local cache. The messages are still
there for all to see. If you delete all your newsgroups and then set them up
again, the messages will download again. Only Microsoft support can
permanently erase messages from the server.

--
Terry Farrell - MSWord MVP

"Anthony" wrote in message
...
On Feb 22, 3:33 am, "Doug Robbins - Word MVP"
wrote:
You cannot delete them. What you could do is post a message in response
to
them advising that the thread is being continued in the vba.general group
so
that anybody who is interested in the subject should go to that group.

Hi Doug,

I did delete the ones that no one answered. Once there is post from
someone, then I cannot delete those posts - I can only delete my own
post.

Everyone, this thread is being continued at:
http://groups.google.com/group/micro...00e2929f496e27

Anrthony