Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel files with list function not opening in Excel 2000
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel files with list function not opening in Excel 2000
Gord and Tom,
Thank you very much for clearing this up. This is the first time I have ever run into a file made in Excel 2003 that wouldn't open in Excel 2000, so I just wanted to make sure that was expected. This helps to clear things up a lot! ~Kyle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening files in Excel 2003 saved in Excel 2000 without data loss... | Excel Discussion (Misc queries) | |||
opening excel 2003 files with excel 2000?? | Excel Discussion (Misc queries) | |||
Does Excel 2000 have the "List" data function like in Excel 2003 | Excel Discussion (Misc queries) | |||
Errors Opening Excel 2000 files in Windows 98 previously saved in | Excel Discussion (Misc queries) | |||
error opening excel 2000 files | Excel Discussion (Misc queries) |