Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 25th 09, 01:18 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default How can I get back my unlost data excel worksheet

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"
<logFileNameerror027520_01.xml</logFileName
<summaryErrors were detected in file 'G:\D.Internet.xls'</summary
- <additionalInfo
<infoExcel 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.

  #2   Report Post  
Old May 25th 09, 01:41 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default How can I get back my unlost data excel worksheet

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"
<logFileNameerror027520_01.xml</logFileName
<summaryErrors were detected in file 'G:\D.Internet.xls'</summary
- <additionalInfo
<infoExcel 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.

  #3   Report Post  
Old May 25th 09, 01:42 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1,104
Default How can I get back my unlost data excel worksheet

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" wrote in message
...
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"
<logFileNameerror027520_01.xml</logFileName
<summaryErrors were detected in file 'G:\D.Internet.xls'</summary
- <additionalInfo
<infoExcel 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.



  #4   Report Post  
Old May 28th 09, 08:21 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 31
Default How can I get back my unlost data excel worksheet

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"
<logFileNameerror027520_01.xml</logFileName
<summaryErrors were detected in file 'G:\D.Internet.xls'</summary
- <additionalInfo
<infoExcel 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.

  #5   Report Post  
Old July 16th 12, 07:02 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 1
Default How can I get back my unlost data excel worksheet

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/


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the headers on an excel worksheet from Numbers back to le Maxine Excel Worksheet Functions 5 August 15th 08 04:10 PM
is there a way to get back deleted worksheet in excel cb517 Setting up and Configuration of Excel 1 July 13th 07 04:56 AM
How do I bring back my worksheet tabs in Excel. Options doesn't Grenier Excel Worksheet Functions 2 May 21st 06 05:55 AM
How do i put back my excel worksheet menu bar crypaz Excel Worksheet Functions 1 April 10th 05 10:40 AM
Excel defaults back to 1st Worksheet okiegrl Excel Discussion (Misc queries) 2 March 14th 05 07:38 PM


All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017