Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 14-05-2011
Member
 
Join Date: Jan 2011
Posts: 104
Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error
  

We are just attempting to do a mail merge via Word 2010. If you utilize Excel files that was initially saved when using 2007 or if new files, 2010 got the error message: External table not in the expected format. If we go back and open the Excel file and "save as" Excel 97-2003 file, then the combination works. Is there anything we can do to change this situation? It affects all computers in our university that just upgraded to Windows 7 / Office 2010.

Reply With Quote
  #2  
Old 14-05-2011
Member
 
Join Date: May 2008
Posts: 913
Re: Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error

If Excel requests for the password, As far as I know, that's the only way you can open an Excel workbook with a password protected as a mail merge source, and if so, you have to do the same in 2007 (must go to the Word Office key Word Options-Advanced-General and check "Confirm file format conversion on unlock", after that cgo via the connection procedure and choose DDE when provided. And I have to say in my experience there are more troubles in 2007, for example, DDE do not even offer all the 255 columns that were possible on a sheet of Excel 2003.
Reply With Quote
  #3  
Old 14-05-2011
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error

Has there been a fine response for this trouble? The answer stated does not look to address the trouble Excel is not asking for a password. As well, Office 2010 does not look to play fine with any Adobe products. It looks to be far more unwieldy to save items out into the PDF format (just way to do is manifold clicks to print to PDF or send to one note to save as PDF, as opposite to the earlier easy save as function.). Very aggravated at the new office package!
Reply With Quote
  #4  
Old 14-05-2011
Member
 
Join Date: May 2008
Posts: 979
Re: Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error

If there at a standstill isn't a way out to this trouble, the following worked for me. I had the similar trouble with the Office 2010 mail merge using Excel and Word. After that, I executed a mail merge by means of Word and Access. After that I observed I could execute the Excel and Word mail merge lacking trouble. I reimaged my test computer with Windows 7 and Office 2010. Performed similar mail merge by Excel and Word and had similar trouble. I started Access and then exited. I can currently achieve the mail merge with Word and Excel with no trouble.
Reply With Quote
  #5  
Old 14-05-2011
Member
 
Join Date: Nov 2008
Posts: 996
Re: Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error

Here I also wish to add something in this case. Opening and after that closing Access looks to be the key. There have to be something which Access runs that Word truly necessitates making the mail merge procedure work with Excel. With any luck next edition will see a fix to this trouble, what to people that don't have Access do (a few of my clients plunge into these circumstances)? I will have to memorize to get them to save their Excel sheets at 97-2003 editions.
Reply With Quote
  #6  
Old 19-05-2011
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error

I don't memorize having any trouble on this particular one. Are you utilizing Access quite often anyhow, or was this the primary time you ran it on that particular machine? I as well speculate whether people who have shaped a new Recipients catalog from within the Word Mail merge function at a few point would as well pass up this trouble (because that utilizes Jet to manipulate the data source).
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error"
Thread Thread Starter Forum Replies Last Post
Getting error 'Unable to connect to printer' while printing from MS word and MS excel 2010 Madhabi Windows Software 8 03-12-2011 10:35 PM
Mail Merge not working in Word 2010 Raja Ram Windows Software 5 19-05-2011 10:20 AM
Excel Error message: "External table is not in the expected format" X-quisite Windows Software 4 29-11-2010 10:59 AM
How to merge excel and word document? Rahman Khan Windows Software 2 07-05-2009 09:39 PM


All times are GMT +5.5. The time now is 07:52 PM.