Hello all,
I am able to delete the sheets if a sheet is having formula,but my sheet contains some defined names also which may or may not have referenced by other sheets.
i am getting this recovery message when i am trying to open the spreadsheet.I am getting this message even if i have deleted the sheets which is reffering the defined name.
for e.g. i have a workbook of 10 sheets, which contains some user defined names also.
'Sheet1' contains a range and a defined name 'X' has been assigned to that range. 'X' has been used by 'Sheet2' and 'Sheet3'.I am not able to delete 'Sheet1' even if i deletes the 'Sheet2' and 'Sheet3' by opening the worksheet from office application.
I beleive 'Sheet1' and defined name 'X' keeps some relational information some where else too and that also needs to be removed.
1 reference i found in workbook.xml, which i deleted and saved but i did this by navigating the workbook.xml and deletes the node and saved.
Recovery Error message while opening the Spreadsheet.
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error040800_01.xml</logFileName>
<summary>Errors were detected in file 'D:\Vikas\testdata\10ENDP1.xlsx'</summary>
- <removedFeatures summary="Following is a list of removed features:">
<removedFeature>Removed Feature: Named range from /xl/workbook.xml part (Workbook)</removedFeature>
</removedFeatures>
</recoveryLog>
Any help or tip will be greatly apprfeciated.
Vikas