excel data lost?

[Guest]

Hi all. My colleague created an excel file using excel 2000 but when my other
colleague open it with excel 2003 he was prompted "this workbook was last
saved by an earlier version of excel. The following data may have been lost:
*list". Does it mean that some data is really lost? Is there any way to
prevent this error message. Thks in advance.

 

[Dave Peterson]

Data|List was added in xl2003.

And excel uses the same name hidden range name 'sheetnamehere'!_filterdatabase
to represent the range that was changed into a list and the range that is used
in Data|filter|autofilter.

This part is a guess.

I'm guessing that xl2003 sees that hidden name and gets confused and issues that
warning.

If the xl2k user creates a new workbook with no data|filter|Autofilter and saves
that, does the problem go away when the workbook is opened in xl2003?

More guesses...

I didn't see any other name that could be causing the trouble, but maybe the
xl2k user is creating a name that isn't allowed in xl2003.

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Then open the workbook in xl2k and see what the name manager shows.

Then do the same thing in xl2003 to see if there's a difference.