I can't open my orginal worksheet with data.It has been lost and
showw message
"Excel recovered your formulas and cell values, but some data may have been
lost."

and When I click"Click to view log file listing repairs
C:\Docume~1\ADMIN~1\LOCALS~1\TEMP\ERROR003160 01.XML"
It show error coding
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error027520_01.xml</logFileName>
<summary>Errors were detected in file 'G:\D.Internet.xls'</summary>
- <additionalInfo>
<info>Excel recovered your formulas and cell values, but some data may
have been lost.</info>
</additionalInfo>
</recoveryLog>
May I Know ,How can I do to get back original worksheet with unlost data.

Hi,
What the log is telling you is where the recovery file is save, that message
that you got is standard usually you don't loss any data, however if you want
to be sure the only way is to recover the information from a backup
if this helps please click yes, thanks

"kyaw" wrote:

> I can't open my orginal worksheet with data.It has been lost and
> showw message
> "Excel recovered your formulas and cell values, but some data may have been
> lost."
>
> and When I click"Click to view log file listing repairs
> C:\Docume~1\ADMIN~1\LOCALS~1\TEMP\ERROR003160 01.XML"
> It show error coding
> <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
> - <recoveryLog
> xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
> <logFileName>error027520_01.xml</logFileName>
> <summary>Errors were detected in file 'G:\D.Internet.xls'</summary>
> - <additionalInfo>
> <info>Excel recovered your formulas and cell values, but some data may
> have been lost.</info>
> </additionalInfo>
> </recoveryLog>
> May I Know ,How can I do to get back original worksheet with unlost data.

After you saw this error, did you save the workbook. If so then all is lost.
If you did not save the workbook there is a slim chance. Others have
reported that Open Office sometimes can open a corrupt Excel workbook and
allow the users to resave it in Excel format.
Open Office is free from http://download.openoffice.org/index.html
I have never used this method to recover a file but I know others who have
done so
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kyaw" <(E-Mail Removed)> wrote in message
news:49274590-0960-40AD-BBCD-(E-Mail Removed)...
>I can't open my orginal worksheet with data.It has been lost and
> showw message
> "Excel recovered your formulas and cell values, but some data may have
> been
> lost."
>
> and When I click"Click to view log file listing repairs
> C:\Docume~1\ADMIN~1\LOCALS~1\TEMP\ERROR003160 01.XML"
> It show error coding
> <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
> - <recoveryLog
> xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
> <logFileName>error027520_01.xml</logFileName>
> <summary>Errors were detected in file 'G:\D.Internet.xls'</summary>
> - <additionalInfo>
> <info>Excel recovered your formulas and cell values, but some data may
> have been lost.</info>
> </additionalInfo>
> </recoveryLog>
> May I Know ,How can I do to get back original worksheet with unlost data.

Hi Kyaw,


I would suggest you to open the Ms-Excel first then click the Open menu and
select the file.
Do not open the file directly, Once you select the file in the dialog box
then "Open" button will be highlighted/Enabled, near to that button you will
find a dropdown, click there.
You will get list of options for opening that file.
Click the "Open and Repair" option.

I think, this will help you and you will not lose your data, and once you
opened the file, save it with different name using "Save As".



Good Luck,
Sanjay


"kyaw" wrote:

> I can't open my orginal worksheet with data.It has been lost and
> showw message
> "Excel recovered your formulas and cell values, but some data may have been
> lost."
>
> and When I click"Click to view log file listing repairs
> C:\Docume~1\ADMIN~1\LOCALS~1\TEMP\ERROR003160 01.XML"
> It show error coding
> <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
> - <recoveryLog
> xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
> <logFileName>error027520_01.xml</logFileName>
> <summary>Errors were detected in file 'G:\D.Internet.xls'</summary>
> - <additionalInfo>
> <info>Excel recovered your formulas and cell values, but some data may
> have been lost.</info>
> </additionalInfo>
> </recoveryLog>
> May I Know ,How can I do to get back original worksheet with unlost data.

To achieve instant recovery of damaged Excel file, you can use Kernel for Excel that ensures perfect recovery. This tool repairs both .xls and .xlsx files by scanning the files recursively. The output it yields never gets altered during recovery process and is presented in the same format as it was previously. Also, the software is quite handy, portable and user friendly. 4 more information http://www.excelfilerepair.net/