View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel files with list function not opening in Excel 2000

The DataList function was introduced with Excel 2003 and is not backward
compatible.

Before opening the Excel 2003 workbook in 2000 you can convert the List to a
Range.

DataListConvert to Range.

Save the file.


Gord Dibben MS Excel MVP


On Tue, 29 Apr 2008 08:32:03 -0700, Kyleonthweb
wrote:

I have some Excel files created in Excel 2003 which have made use of the list
command under Data - List. These files lock up Excel 2000 when it tries to
open them. If we remove the tab with the list function to another file, then
the file will open, and the new file with the list function information still
will not open, so it does seem to be that particular function that it doesn't
like.

Is that to be expected for files with the list function active? Is there a
way to get these files to open correctly in Excel 2000?

Thank you,
~Kyle