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

Sponsored Links



Excel Error message: "External table is not in the expected format"

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-11-2010
Member
 
Join Date: Oct 2010
Posts: 111
Excel Error message: "External table is not in the expected format"
  

Hello friends recently I have updated my Office to 2007 and it was working pretty well until yesterday when I found out that when I was loading the data from any external entity I was getting this error "External table is not in the expected format". This kind of problem is coming only after the updation as I was not getting that when I was using Office 2003. I was successful able to load the external data without any problem. So can any one help me to know why is this happening and what can be done to overcome this kind of problem.

Reply With Quote
  #2  
Old 29-11-2010
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Excel Error message: "External table is not in the expected format"

Hey during the time of the installation of the Office 2007 have you selected the file association of that would be supported by this software. The file association decides what are all the files that would be imported using this software. I think that the data which you are trying to import from the external entity is not in the file association of the software. So first you have to select the file association to help you get the data bu reinstalling the software from the very beginning and then make sure that you select all the possible files that you want to get imported using this software. I hope you understand what I am trying to say.
Reply With Quote
  #3  
Old 29-11-2010
Member
 
Join Date: Nov 2008
Posts: 996
Re: Excel Error message: "External table is not in the expected format"

Hey this is how I import data from the external source, and I dont have any problem in importing any data. Firstly you have to go under the Data menu and then select the "get external data". You will be given a list of source from where you want to get the data. Now click on the file which you want and then select open and you will be able to import the data of the files that you want in your excel sheet. You can try this and you will automatically be able to get whatever data you want.
Reply With Quote
  #4  
Old 29-11-2010
Member
 
Join Date: Oct 2010
Posts: 111
Re: Excel Error message: "External table is not in the expected format"

Hey I am also using the same technique to get the data but the also I am getting this error "External table is not in the expected format". I have tried several different formats and then also I ma not able to get the data. The problem is that I don't have the setup copy of this software with me as I had taken it from a friend of mine who is currently out of town, so it would not be possible for me to install the software during this time. So can any help me get this problem solved without reinstalling the software.
Reply With Quote
  #5  
Old 29-11-2010
Member
 
Join Date: May 2008
Posts: 979
Re: Excel Error message: "External table is not in the expected format"

Hey I would want to know that which kind of files are you looking to import, if it is a xls file then I don't think so that there could be any problem in importing the files, but if it is some other files then I guess you have to convert the files into xls, before directly importing to the Excel 2007. These converters are available for free and you can download this from the internet. Also, if some of the Office 2003 files are also not importing then you can use this converter to make the file supported by Office 2007.
Reply With Quote
Reply

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



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel Error message: "External table is not in the expected format""
Thread Thread Starter Forum Replies Last Post
Unable to filter correctly while click on "Format as a Table" button in excel Gustav m Windows Software 6 15-07-2011 12:10 AM
Word/Excel 2010 Merge: Getting “External table is not in the expected format” error Satguru Windows Software 5 19-05-2011 11:18 AM
Error message "Old format or library type is invalid" when automating Excel PsYcHo 1 Windows Software 5 30-03-2010 06:21 AM
Nokia 5130gives "Format Not Supported" error message KAILEY Portable Devices 4 25-01-2010 11:06 PM
Project Web Access via IE7: "Export Grid to Excel" cause VBSCRIPT (error) message: "The activeX control on which this feature depends could not be created" Theo-Dore Microsoft Project 2 17-01-2007 09:47 PM


All times are GMT +5.5. The time now is 10:38 AM.