Remove Message "Opening this will run the following SQL command" when you open a Word mail merge

When you open a mail merge main document in Microsoft Office Word, you experience one of the following symptoms:

You receive the following prompt:

Opening this document will run the following SQL command:

SELECT * FROM your datasource

Data from your database will be placed in the document. Do you want to continue?

Note If you click Yes, the mail merge main document opens with the data source attached. If you click No, the mail merge main document opens without the data source attached.

In Microsoft Office Word 2007, perform the following action while the prompt is displayed:

To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:

201235

A mail merge main document that is opened by using Microsoft Visual Basic for Applications(VBA) does not have the data source attached.

Note It could be that you are using a program, for example Microsoft Access or Microsoft Visual FoxPro, to programmatically open a mail merge main document file when you experience the symptoms in this article.

To disable the security prompt by using the
SQLSecurityCheck
registry key, follow the appropriate steps for your version of Microsoft Word.

Word 2013

HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options 

"SQLSecurityCheck"=dword:00000000

1. Start Registry Editor.
2. Locate and then click the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options
3. On the Edit menu, point to New, and then click DWORD Value.
4. Under Name, type:
   SQLSecurityCheck
5. Double-click SQLSecurityCheck.
6. In the Value data box, type:
   00000000
7. Click OK.

Very Slow Open Word Hyperlinks From Microsoft Excel 2013

We got an answer from Microsoft that seems to work like a charm - needless to say we are very pleased
It involves adding two new Registry Keys
Here are the details
Set the DelayOleSrvParseDisplayName registry entry and the NoActivateOleLinkObjAtOpen registry entry to enable the hotfix. To do this, follow these steps:

1. Start Registry Editor by clicking  Start, click Run, type regedit in the Open box, and then click OK.
2. Locate and then select the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options
3. On the Edit menu, point to New, and then click DWORD Value.
4. Type DelayOleSrvParseDisplayName, and then press ENTER.
5. Right-click DelayOleSrvParseDisplayName, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. On the Edit menu, point to New, and then click DWORD Value.
8. Type NoActivateOleLinkObjAtOpen, and then press ENTER.
9. Right-click NoActivateOleLinkObjAtOpen, and then click Modify.
10. In the Value data box, type 1, and then click OK.
    Make sure you do like this

11. On the File menu, click Exit to exit Registry Editor

12. Close Excel & open again

Define and use names in formulas

By using names in formula, we can can make own formulas much easier to understand and maintain later. we can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in our workbook, we can easily update, audit, and manage these names.

Learn more about using names

Using A name is a meaningful shorthand that makes it easier to understand the purpose of a cell reference, constant, formula, or table, each of which may be difficult to comprehend at first glance. The following information shows common examples of names and how they can improve clarity and understanding.

To define name is very simple just put your name in Name Book  This is simple tips for using name and this trick is very useful to use, if you are ready to use and using many names for your formula, you can managed define name from Formulas Menu