Saving a Report in Excel

MCWA · Post by **MCWA** » Wed Nov 14, 2007 5:39 pm

Version #: 10.4
Microsoft Office 2007
Problem: When I try to save any report in Excel I get an error message that states: "File error: data may have been lost."
Does PC+ have a fix for this problem?

Post by **Zorak** » Thu Nov 15, 2007 12:05 pm

Are there any other errors or messages before or after this one?

Any other information conveyed on the error message itself?

MCWA · Post by **MCWA** » Fri Nov 16, 2007 5:00 pm

No other errors or messages before or after error message.
No additional information conveyed in error message itself.

Al · Post by Al » Mon Feb 11, 2008 5:01 pm

Is the data, indeed, lost. Have you tried to save it with a modified name and then open after the report is created?

Have you tried comma-delimited or text file types? or Word doc?

Al

adriennec · Post by **adriennec** » Thu May 15, 2008 1:44 pm

FWIW, I'm getting the same error, but no data seems to have been lost. I'm not sure what's triggering the error, unless it's because I'm now using MS Office 2007.

All the other file formats open properly: .DOC, .RTF, .TXT, .HTML, .PDF. PowerChurch only grumbles about .XLS.

Post by **Zorak** » Thu May 15, 2008 2:23 pm

OK, thanks for following up with this.

In our internal testing, this error occurs in Excel 2003 (Service Pack 3) & 2007 and is most likely related to the new security precautions that they are taking in the updated versions of Microsoft Office.

This is the same issue that will make Word documents created in PowerChurch (or any version of Word other than 2003 SP3 or 2007) say that they are incompatible and will not open.

In the brief research that we have done, the data that "may be lost" is any internal scripting that is written into the file (which, coming from PowerChurch Plus, there is none) is being stripped out to comply with the new security settings.

adriennec · Post by **adriennec** » Thu May 15, 2008 2:57 pm

Thanks for your reply. It's good to know I can safely ignore that "error" message, since it's more of a precautionary warning in Excel than a true error message.

(What I should have said was "Excel grumbles about opening the file", not PowerChurch.

)

MTZDetroit · Post by **MTZDetroit** » Fri Jan 09, 2009 3:50 pm

I found this solution on the Microsoft support site:

http://support.microsoft.com/kb/938810

Michael Sanchez
PC+ 9 User 3 Years
Clarkston, MI