How to permanently link Word to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1362804%22%20slang%3D%22en-US%22%3EHow%20to%20permanently%20link%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1362804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EGood%20Morning%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20created%20a%20Word%20file%20that%20links%20to%20an%20excel%20sheet%2C%20to%20print%20work%20contracts.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EBut%2C%20whenever%20I%20open%20Word%2C%20a%20window%20appears%20warning%20that%20an%20SQL%20command%20%22Select%20From%20...%22%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20it%20possible%20to%20prevent%20this%20window%20from%20appearing%20and%20go%20directly%20to%20the%20Word%20file%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20for%20the%20Help.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1419172%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20permanently%20link%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419172%22%20slang%3D%22en-US%22%3E%3CP%3E-ERR%3AREF-NOT-FOUND-%40Carlos_Soares%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20I%20understand%20your%20question%20correctly%3F%20You%20have%20a%20Word%20document%20that%20contains%2C%20I'm%20assuming%2C%20the%20texty%20part%20of%20a%20contract%20or%20business%20proposal%20and%20you've%20linked%20it%20to%20Excel%2C%20which%20does%20the%20numbers%20part.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20encountered%20the%20SQL%20dialog%20box%20myself%20and%20discovered%20that%20if%20it's%20the%20same%20Word%20doc%20and%20same%20Excel%20file%20(no%20name%20changes%20or%20saving%20to%20a%20different%20folder)%2C%20it%20doesn't%20come%20up.%20But%20that's%20not%20very%20real%20world%2C%20is%20it%3F%20You%20want%20to%20be%20able%20to%20save%20a%20unique%20Excel%20spreadsheet%20for%20each%20client%2Fcustomer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20embedding%20the%20Excel%20spreadsheet%20work%20for%20you%3F%20Or%20is%20it%20multiple%20worksheets%20long%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20your%20Word%20document%20%3CSTRONG%3ETEMPLATE%3C%2FSTRONG%3E%2C%20go%20to%20Insert%20Ribbon%20%26gt%3B%20Text%20Section%20(near%20right%20end)%20%26gt%3B%20Objects.%20Choose%20Create%20New%20tab%20and%20choose%20Microsoft%20Excel%20Worksheet.%20If%20it%20is%20really%20large%20or%20multiple%20worksheets%2C%20click%20the%20Display%20as%20Icon%20checkbox.%20Otherwise%2C%20you%20can%20make%20it%20look%20like%20a%20table%20in%20your%20Word%20document%2C%20but%20have%20all%20the%20Excel%20tools.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBe%20sure%20to%20save%20your%20Word%20template%20as%20a%20template%2C%20then%20double-click%20on%20it%20in%20File%20Explorer%20to%20create%20a%20new%20contract%20for%20every%20customer.%20Bonus%20feature%3A%20you'll%20never%20have%20to%20worry%20about%20accidentally%20overwriting%20an%20existing%20contract.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Good Morning

I created a Word file that links to an excel sheet, to print work contracts.
But, whenever I open Word, a window appears warning that an SQL command "Select From ..."
Is it possible to prevent this window from appearing and go directly to the Word file?
Thanks for the Help.

1 Reply

@Carlos_Soares 

 

Do I understand your question correctly? You have a Word document that contains, I'm assuming, the texty part of a contract or business proposal and you've linked it to Excel, which does the numbers part.

 

I've encountered the SQL dialog box myself and discovered that if it's the same Word doc and same Excel file (no name changes or saving to a different folder), it doesn't come up. But that's not very real world, is it? You want to be able to save a unique Excel spreadsheet for each client/customer.

 

Would embedding the Excel spreadsheet work for you? Or is it multiple worksheets long?

 

In your Word document TEMPLATE, go to Insert Ribbon > Text Section (near right end) > Objects. Choose Create New tab and choose Microsoft Excel Worksheet. If it is really large or multiple worksheets, click the Display as Icon checkbox. Otherwise, you can make it look like a table in your Word document, but have all the Excel tools.

 

Be sure to save your Word template as a template, then double-click on it in File Explorer to create a new contract for every customer. Bonus feature: you'll never have to worry about accidentally overwriting an existing contract.