Excel 2003- "File Error" data may be lost

[Aaron Graham]

Hi-
We have a Excel solution that is currently running perfectly on all
versions of Excel up to 2002. We now have users try to use Excel 2003
and it is failing. When the workbook is launched we get the message
"File Error data may be lost" from Excel. We have done a bit of
research on this and haven't came up with anything that would help.

We partially believe it is due to our Workbook containing Dialog sheets
(this solution has been evolving ever since Excel 5).

Anyone have any ideas? Will we have to convert all of the Dialog Sheets
to Forms for it to run in Excel 2002, even though it does still
completely compile under 2002?
--
________________________________________________________________________
Aaron Graham - ITA,Inc. Apple Solution Expert: Product Professional
(585)328-7380
1250 Scottsville Rd, Ste 2 mailto:[email protected]
Rochester, NY 14624-5757 http://www.itainc.com

C/C++, Applescript, XML, Photoshop Plug-Ins, Automated QA Testing, SCSI, Firewire,
Filemaker, VB/VBA, Excel
________________________________________________________________________

 

[Jim Rech]

Excel 2003 supports dialog sheets just fine, so I'm not sure what the
problem is. An ordinary manual File, Open in Excel 2003 and you get this
error? I guess I'd have to see it.

 

[Aaron Graham]

Excel 2003 supports dialog sheets just fine, so I'm not sure what the
problem is. An ordinary manual File, Open in Excel 2003 and you get this
error? I guess I'd have to see it.

ok, thanks we are going to have to find out if our client wants to
further explore this or not at this time.

 

[aGraham]

sorry this is so long but I spent most of yesterday working on this to
no avail, and want to give as much detail as possible....

OK we are still trying to figure out what is causing this. I have
stripped the WB down to a single worksheet in Excel 2000 and I am still
having the problem when it opens in 2003. This worksheet contained
comments, that showed they were added by "A satisfied Microsoft Office
user". When I opened this in 2003 I got the File error and then noticed
that the comments were removed. I then removed all of the comments and
this workbook, with a single sheet opened with out the error. I then
wrote a macro to remove all comments from the complete workbook, but
even with out the comments I get the error in the complete Workbook. I
then noticed that the dialog sheets were all empty after it was opened.

I then stripped the WB down to a single dialog sheet, and it fails when
opening. I even tried stripping all of the controls off of the sheet,
and that still fails.

Some other things I tried-
1.) stripped out all of the sheets and added a new blank sheet, that did
open fine.
2.) commented out and then removed all code modules, even though I was
disabling macros still failed


Any other ideas?

I just tried one last thing before I sent this and copied the dialog
sheet to another wb, and the new WB opens fine. I am going to try
moving all of the worksheets to a new wb.

 

[Aaron Graham]

Have spent more time on this today and I am about to pull my hair out!!!!

After I saw that the single dialog sheet worked, I copied all of the
sheets to a new WB and the new WB is now having the same issue, but only
getting a single error message when it opens,(used to get a message for
every sheet). I then found that the controls had been stripped off of
one of the sheets. I then found that there were two unneeded
transparent shapes on the sheet. After deleting them the workbook opens
correctly. I then tried just removing these two shapes from the
original WB and it still failed. So must be a complete combination of
the changes.

Anybody have any ideas on what else to look for before I go through and
do more investigation?