Page 1 of 1

Saving a Report in Excel

Posted: Wed Nov 14, 2007 5:39 pm
by MCWA
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?

Posted: Thu Nov 15, 2007 12:05 pm
by Zorak
Are there any other errors or messages before or after this one?

Any other information conveyed on the error message itself?

Posted: Fri Nov 16, 2007 5:00 pm
by MCWA
No other errors or messages before or after error message.
No additional information conveyed in error message itself.

Posted: Mon Feb 11, 2008 5:01 pm
by Al
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

Posted: Thu May 15, 2008 1:44 pm
by adriennec
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.

Posted: Thu May 15, 2008 2:23 pm
by Zorak
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.

Posted: Thu May 15, 2008 2:57 pm
by adriennec
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. :) )

Posted: Fri Jan 09, 2009 3:50 pm
by MTZDetroit
I found this solution on the Microsoft support site:

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

Michael Sanchez
PC+ 9 User 3 Years
Clarkston, MI