My company uses a Terminal Server environment to run some very
specialized programs not associated with the MS Office 2000 Suite also
installed on the Terminal Server. Salesmen in the field often find it
more favorable to use a terminal server session verses the VPN to
conduct their emails and daily data entry. The problem I am having is
that though the TS has MS Excel '00 on it, my local station runs '03.
Any time I open an Excel document saved in Excel '00 which has Macro's
or just Form controls, I get an error message that says "File error:
Data may have been lost." Upon review of the workbook I find that all
of the form controls have been lost. This is not a major concern, but
a source of confusion. The one workbook which now displays this issue
is one I created in Excel '03 and saved it as a template for others to
open, fill-in, and re-submit to me. It seems that once they have been
opened and re-saved in Excel '00 (which opens the workbook with no
issues) the file then reports the Error: Data Loss when opened in '03.
Any ideas?