Home > Unable To > Word Error Word Was Unable To Open The Datasource Avery

Word Error Word Was Unable To Open The Datasource Avery

Contents

The time now is 12:04 AM. - Contact Us - Microsoft Word Forum WordBanter forum home - FAQ - Links - Privacy Statement - Top Powered by vBulletin Version 3.6.4Copyright ©2000 Thanks. "Peter Jamieson" wrote: I would expect DDE to work OK in Windows XP - it is OK here, for example. If you have not tried already, try opening your Excel document first, then making the connection. woodb, Oct 20, 2016, in forum: Business Applications Replies: 5 Views: 132 DaveA Nov 2, 2016 at 12:42 PM Solved Use Bookmarks to Fill in a Word Doc from Excel mohammadH123, click site

it is very easy for DDE conversations to be blocked by a single badly-behaved program (which is one of the reasons DDE was "deprecated" many years ago). Copyright 2004-2016 Microsoft Office Word Forum - WordBanter. Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. slurpee55, Dec 15, 2009 #8 Sponsor This thread has been Locked and is not open to further replies. https://support.microsoft.com/en-us/kb/888697

Word Was Unable To Open The Data Source Excel

Thank you for helping us maintain CNET's great community. unless you happen to know that 0 always means that the original entry was blank. This second date is the issue. For the second problem you can change { MERGEFIELD mynumber } to { MERGEFIELD mynumber \#"0.00;-0.00;''"} (or if it is your percentage field that can have blanks, use { ={ MERGEFIELD

I didn't do anything different that I have before. Password Register FAQ Today's Posts Search Search Forums Show Threads Show Posts Tag Search Advanced Search Go to Page... No, create an account now. Word 2013 Mail Merge Unable To Open Data Source I haven't checked this myself.

Staff Online Now Cookiegal Administrator TerryNet Moderator Macboatmaster Trusted Advisor Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Forums Word 2013 Word Was Unable To Open The Datasource This module is called in many places in this project, and there are only 2 specific mail merge templates that do not work. 2. LinkBack Thread Tools Display Modes #1 03-14-2014, 12:02 PM meganadand Windows 7 64bit Office 2010 64bit Novice Join Date: Jan 2014 Posts: 3 "word was unable to open unless you happen to know that 0 always means that the original entry was blank.

Another way to try to get the data as you see it in Excel is to Edit-Copy the data from the worksheet and paste it into a Word document, then use Word Was Unable To Open The Data Source Mac Once reported, our moderators will be notified and the post will be reviewed. To start viewing messages, select the forum that you want to visit from the selection below. Short URL to this thread: https://techguy.org/885079 Log in with Facebook Log in with Twitter Log in with Google Your name or email address: Do you already have an account?

  1. The error message refers to an .xls format, but the document is in and .xlsx format.
  2. when using OLE DB, but not this one Also, blank fields in Excel dispay the value zero (0) when merged in Word.
  3. it is very easy for DDE conversations to be blocked by a single badly-behaved program (which is one of the reasons DDE was "deprecated" many years ago).
  4. By formatting the date using convert(varchar(10), TBL.dateUsed, 121) as mergeDate the template generates successfully.
  5. I also tried copying the issue template to the same folder as another template that works, and this also did not work.
  6. Which version of Windows?
  7. However, when I Finish & Merge, the data merged into Word look different than what it should and how it appears in Excel.
  8. I tried changing the filename to .xls (originally .xlsx) but it didn't work.
  9. Any help to correct this is greatly appreciated.
  10. unless you happen to know that 0 always means that the original entry was blank.

Word 2013 Word Was Unable To Open The Datasource

You may have to register before you can post: click the register link above to proceed. https://forums.techguy.org/threads/solved-word-cannot-open-excel-data-source.885079/ Specifically, they have mentioned making Firefox the default. Word Was Unable To Open The Data Source Excel Then in lowr left task bar it briefly says "Opening file . . . ." but then I am prompted with Word error "Word was unable to open the data source." Word Was Unable To Open The Data Source Word 2010 The system returned: (22) Invalid argument The remote host or network may be down.

Preview post Submit post Cancel post You are reporting the following post: "word was unable to open the data source" error message This post has been flagged and will be reviewed http://itechnologysolutionsllc.com/unable-to/vlc-2-0-3-unable-to-elevate-error-1814.php I am far from an expert in VBA, I havn't even been using it for 4 months, so I could be missing the issue/point entirely. How the MacBook Pro's Touch Bar works The MacBook Pro now has a digital function bar that's actually a dynamic screen. Advertisement Recent Posts Ok so which Win7 service pack1... Word Was Unable To Open The Data Source 2016

You can try to ensure that only Word and Excel are open and see if that makes any difference. Is it Vista? 2. Thanks! navigate to this website Another way to try to get the data as you see it in Excel is to Edit-Copy the data from the worksheet and paste it into a Word document, then use

If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. Mail Merge Can't Open Data Source This did not work. Specifically, numbers formatted as percetages with 0 decimal places in Excel (22%) appear as 0.2187539 when merged into Word.

Picture.

You can fix this problem by using "formatting switches" in Word: numbers formatted as percetages with 0 decimal places in Excel (22%) appear as 0.2187539 when merged into Word. READ MORE © CBS Interactive Inc.  /  All Rights Reserved. nancy4, Dec 14, 2009 #5 slurpee55 Joined: Oct 20, 2004 Messages: 7,837 According to MS, the reasons for this are: * Your data source is not located on your computer--for example, Word Was Unable To Open The Data Source Mail Merge Access One or two people have reported that they have solved their DDE connection problems by changing their default Windows browser so that Internet Explorer is not the default.

when using OLE DB, but not this one Also, blank fields in Excel dispay the value zero (0) when merged in Word. Specifically, they have mentioned making Firefox the default. The time now is 04:04 PM. -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top Powered by vBulletin Version 3.8.1Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. my review here It is certainly possible for Internet Explorer or a plug-in to interfere with DDE as a whole.

So can you explain why that would be different for barcodes?Kees Flag Permalink Reply This was helpful (0) Collapse - problem with control chars by rachel_c / August 27, 2009 6:39 nancy4, Dec 12, 2009 #1 Sponsor James4630 Joined: Mar 1, 2009 Messages: 82 You might get more response in the business application forum. Peter Jamieson http://tips.pjmsn.me.uk On 05/02/2010 02:15, rickcstahl wrote: My problem is that my Excel data is not being "mail merged" into Word. Thanks. "Peter Jamieson" wrote: 1.

I tried the formatting suggestions, but when mail merged using OLE DB into word revealed instead of the percentage the following: Error ! Solved: word cannot open excel data source Discussion in 'Business Applications' started by nancy4, Dec 12, 2009. Is it Vista? 2.

Follow us