Masuk
 
AwalPerpustakaanWikiPelajariUnduhDukunganKomunitasForum
Resources for IT Professionals >
> 
> 
Cannot open "Get External Data" in Excel 2010 with a .xls file

Answered Cannot open "Get External Data" in Excel 2010 with a .xls file

  • 10 Januari 2011 17:23
     
     
    Masuk untuk Memilih
    0
    I have a .xls file that requires a XML data input.  In Excel 2010 the "Get External Data" is grayed out.  I have tried saving this file as an Excel 2010 format and it sitll is grayed out.  Any suggestions?
    • Dipindahkan oleh Jennifer ZhanModerator 11 Januari 2011 1:54 (From:Office 2010 Application Compatibility)
    •  
     

Semua Balasan

  • 11 Januari 2011 1:54
    Moderator
     
     Jawab
    Masuk untuk Memilih
    1

    Hi, 

    You could only import 1 set of external data for the worksheet. If you have an old external data, the "get external data" icon will be grayed out. If so, try to clear the old external data.

    Hope that helps.

     
  • 27 Mei 2012 13:47
     
     
    Masuk untuk Memilih
    0

    Hi,

    I am having the same problem as the person you replied to.  Could you help me as well.  How do you clear old external data?

     
  • 06 Juni 2012 23:18
     
     Saran Jawaban
    Masuk untuk Memilih
    0
    I had same problem.  I fixed it by entering Control A to select everything on the sheet and then press delete.  Bad news is I lost the column headers, but I didn't have to create a new page and resize the columns, etc.
    • Disarankan sebagai Jawaban oleh SharkDentist 06 Juni 2012 23:19
    •