Excel doesn't allow to save file instead go for "Save As" after file repairing

%3CLINGO-SUB%20id%3D%22lingo-sub-1479399%22%20slang%3D%22en-US%22%3EExcel%20doesn't%20allow%20to%20save%20file%20instead%20go%20for%20%22Save%20As%22%20after%20file%20repairing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479399%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20moment%20i%20opened%20my%20excel%20file%20where%20usually%20i%20used%20to%20work%2C%20it%20suddenly%20came%20with%20pop%20up%20asking%20to%20allow%20recover%20data%20as%20much%20as%20it%20can%20if%20i%20trust%20the%20file.%20On%20pressing%20%22Yes%22%20it%20repairs%20the%20file%20and%20pop%20ups%20error%20log%20file%20as%20follows%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CRECOVERYLOG%20xmlns%3D%22%26quot%3B%26lt%3BA%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%3CA%20href%3D%22http%3A%2F%2Fschemas.openxmlformats.org%2Fspreadsheetml%2F2006%2Fmain%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fschemas.openxmlformats.org%2Fspreadsheetml%2F2006%2Fmain%3C%2FA%3E%22%26gt%3B%3CLOGFILENAME%3Eerror156680_01.xml%3C%2FLOGFILENAME%3E%3CSUMMARY%3EErrors%20were%20detected%20in%20file%20'C%3A%5CShapoorji%5COracle%20Phase-02%5CFinal%20bill%5CFinal%20Bill-MM-01-Oracle%20Ph-02.xlsx'%3C%2FSUMMARY%3E%3CREMOVEDRECORDS%3E%3CREMOVEDRECORD%3ERemoved%20Records%3A%20Cell%20information%20from%20%2Fxl%2FexternalLinks%2FexternalLink3.xml%20part%20(Cached%20values%20from%20external%20formula%20reference)%3C%2FREMOVEDRECORD%3E%3CREMOVEDRECORD%3ERemoved%20Records%3A%20External%20formula%20reference%20from%20%2Fxl%2FexternalLinks%2FexternalLink3.xml%20part%20(Cached%20values%20from%20external%20formula%20reference)%3C%2FREMOVEDRECORD%3E%3C%2FREMOVEDRECORDS%3E%3C%2FRECOVERYLOG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20this%2C%20I%20could%20able%20to%20work%20in%20my%20file.%20But%20every%20time%20i%20try%20to%20save%20my%20file%2C%20it%20goes%20for%20%22Save%20As%22%20instead%20of%20normal%20save.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELater%2C%20if%20i%20close%20the%20file%20and%20reopen%20the%20same%2C%20it%20again%20comes%20with%20a%20pop%20up%20%22recover%20data%20as%20much%20as%20it%20can%20if%20i%20trust%20the%20file%20source%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20out%20to%20make%20my%20life%20simple%20while%20working%20in%20this%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EMulchandani%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1479399%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1490803%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20doesn't%20allow%20to%20save%20file%20instead%20go%20for%20%22Save%20As%22%20after%20file%20repairing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490803%22%20slang%3D%22en-US%22%3ETry%20to%20SaveAs%20the%20file%20under%20a%20new%20name.%20If%20the%20file%20is%20saved%20to%20OneDrive%20it%20will%20not%20have%20the%20Save%20button%2C%20so%20long%20as%20AutoSave%20is%20turned%20on.%20From%20your%20images%20it%20appears%20this%20setting%20is%20turned%20off%2C%20so%20I'd%20try%20saving%20a%20new%20copy%20and%20seeing%20what%20it%20does%20then.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

 

The moment i opened my excel file where usually i used to work, it suddenly came with pop up asking to allow recover data as much as it can if i trust the file. On pressing "Yes" it repairs the file and pop ups error log file as follows 

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error156680_01.xml</logFileN... were detected in file 'C:\Shapoorji\Oracle Phase-02\Final bill\Final Bill-MM-01-Oracle Ph-02.xlsx'</summary><removedRecords><removedRecord>Removed Records: Cell information from /xl/externalLinks/externalLink3.xml part (Cached values from external formula reference)</removedRecord><removedRecord>Removed Records: External formula reference from /xl/externalLinks/externalLink3.xml part (Cached values from external formula reference)</removedRecord></removedRecords></recoveryLog>

 

After this, I could able to work in my file. But every time i try to save my file, it goes for "Save As" instead of normal save. 

 

Later, if i close the file and reopen the same, it again comes with a pop up "recover data as much as it can if i trust the file source"

 

Please help me out to make my life simple while working in this excel.

 

Regards,

Mulchandani

1 Reply
Highlighted
Try to SaveAs the file under a new name. If the file is saved to OneDrive it will not have the Save button, so long as AutoSave is turned on. From your images it appears this setting is turned off, so I'd try saving a new copy and seeing what it does then.