#1
|
|||
|
|||
"word was unable to open the data source" error
Hi,
I have used a specific file the last 4 months for my mail merge. All of a sudden it stopped working... ??? I didn't do anything different that I have before. When I try to import the data into mail merge, none of my tables show up (see attachment). Then, when I select "ok", it tells me that Word is unable to open the data source. Any suggestions??? Thanks! |
#2
|
||||
|
||||
I note your profile says you're using Office 2010, but the error message refers to an .xls format worksheet, which is the older format. Are you sure your workbook is still in the .xls format and hasn't been changed to the newer .xlsx format?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
You're right. The error message refers to an .xls format, but the document is in and .xlsx format. What do I need to do to fix it and why did that change?
Here are the document properties: |
#4
|
||||
|
||||
Simply select the correct file as the data source, save the updated file, then continue as before. For example (assuming you're still getting the SQL prompt upon opening the document), when the 'Data Link Properties' dialogue pops up, simply add the missing 'x' to the end of the file extension.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thanks, but I already tried that - it won't let me edit the file extension. Any other suggestions?
|
#6
|
||||
|
||||
The 'Connections' panel on that dialogue allow you to change the entire file path & name, if need be - but the change won't be saved. For a permanent update, simply answer 'No' to the initial SQL prompt when you open the document, then use 'Select Recipients' on the Mailings tab to navigate to and select the correct workbook.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
The exact same thing happened to me!! I figured what was wrong. May be your issue as well:
Check your other sheets in your document. One of the other sheets was hi-lighted to be copied and it was saved that way by mistake. Once I un-highlighted the cell on the other sheet, my mail merge went through perfectly. |
Tags |
excel 2010, mail merge problem, word 2010 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error: "Changes made were lost...reconnect with server", when switching "from" field | randhurrle | Outlook | 2 | 02-25-2015 06:51 PM |
"Unable to display the folder" error on viwing another Mailbox | AlexTeslin | Outlook | 2 | 10-21-2013 09:30 AM |
Automation error Unknown error" message once they open the Excel file | hlina | Excel | 1 | 10-08-2013 09:14 PM |
Word 2003 "The information you were working on might be lost" constant error message | rocketbeta | Word | 1 | 08-21-2012 02:54 PM |
"open" or "open using" option not availa | ccd | Outlook | 0 | 09-22-2006 01:23 AM |