Excel Application for Office 2002 displays error in Office 2003

[kaustav choudhury]

Hi,

My MS Excel 2002 application containing macros displays errors (Data Error:
Data may be lost) and removes all buttons from the application when opened
in MS Excel 2003. Strangely this behaviour is not consistent across all MS
Excel 2003 installations. My operating system is Windows XP.

Is this a compatibility problem between Excel 2002 and Excel 2003 macros.
Please help.

Kaustav

 

[Dave Peterson]

I don't own xl2003, but xl2002 has the same feature.

If it thinks the workbook is corrupted, then it tries to recover as much as it
can.

Are the different xl2003 users opening the same file (from a network drive???)
or are they opening their own copies?

If each is opening their own copy, I'd send a fresh copy to the user with the
trouble.


Wild guesses follow:


If all are opening the same, then that sounds like a different problem.
Unencumbered by the thought process, I sounds like it might not be the workbook.

Maybe you could try Help|Detect and Repair on the problem PC.

If it turns out to be the file, then I would suspect that the problem will soon
appear on the other pc.

OpenOffice might be able to open it and you might be able to save lots of work.
(http://www.openoffice.org, a 60-65 meg download or a CD)

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com

 

[kaustav choudhury]

Hi,



Each user uses a separate file and not a file shared over the network. The
problem is that the same copy is running perfectly on Excel 2002 over
windows XP and widows 2000. This problem is present in some of the Excel
2003 and not all. I was wondering if Excel 2003 requires some additional
updates/patches (especially for security purposes as I password protect my
VBA code along with excel sheet) that are not a concern for Excel 2002
system.



If you know of any such requirements please do forward me the relevant
information.



Thanks,



Kaustav

 

[Dave Peterson]

I'm not aware of any updates/patches.

But if they each have their own files, how about sharing one from a pc that
works with the pc that doesn't work. If that copy works ok, I'd dump the
original copy. (I still suspect something bad happened to the file between you
sending it and the receiver getting it.)

Maybe something bad happened in the email. If you distributed via floppy/CDROM,
maybe something bad happened there.

I think I'd try to eliminate the easiest things first.