prompted each time for merge source

[Bryan]

I use an Excel document to merge my students' scores into
a Word doc which I use as a periodic report for their
grades. It works beautifully when it's open and doing its
job, except that when I started using Word 2003, whenever
I open the document, I see a prompt asking if it's OK to
insert data from the appropriate worksheet into this
document. This is a little annoying because the doc was
saved that way so why should I have to say OK again to
open it; but it's not that big of a deal to click the Yes
button. The biggest annoyance comes in that it does not
insert the data from that worksheet, rather it starts me
from square one, prompting for the merge file way back in
My Data Sources. My questions: Why does it take me
through this complete process when the file opens, and is
there a way to turn off this prompt?

 

[Cindy M -WordMVP-]

Hi Bryan,

I use an Excel document to merge my students' scores into
a Word doc which I use as a periodic report for their
grades. It works beautifully when it's open and doing its
job, except that when I started using Word 2003, whenever
I open the document, I see a prompt asking if it's OK to
insert data from the appropriate worksheet into this
document.

This sounds like the new security prompt? See if this KB
article addresses the issue

"Opening This Will Run the Following SQL Command" Message
When You Open a Word Document - 825765
http://support.microsoft.com?kbid=825765

Note for future help requests: You should carefully note
down the exact wording of any messages Word is showing you.
Sometimes, our crystal balls aren't working clearly, and we
end up giving you the answer to a different question...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Guest]

Thanks! It worked.

-----Original Message-----
Hi Bryan,

This sounds like the new security prompt? See if this KB
article addresses the issue

"Opening This Will Run the Following SQL Command" Message
When You Open a Word Document - 825765
http://support.microsoft.com?kbid=825765

Note for future help requests: You should carefully note
down the exact wording of any messages Word is showing you.
Sometimes, our crystal balls aren't working clearly, and we
end up giving you the answer to a different question...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail


.