View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Excel files with list function not opening in Excel 2000

The LIST command was new in Excel 2003, so it's not surprising Excel 2000
doesn't know what to do with a file using it. I have searched but have not
found a workaround. Unless somebody else knows a way, I think you will have
to convert the List back to a normal range to use that workbook in Excel
2000.

Hope this helps,

Hutch

"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