SOLVED

Excel Version Compatibility

%3CLINGO-SUB%20id%3D%22lingo-sub-1474393%22%20slang%3D%22en-US%22%3EExcel%20Version%20Compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1474393%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20support%20a%20user%20who%20works%20with%20o365%20Excel%20%3CSTRONG%3E64-bit%3C%2FSTRONG%3E.%20She%20has%20a%20worksheet%20shared%20with%20a%20team%20who%20all%20use%20Excel%202016%20%3CSTRONG%3E32-bit%3C%2FSTRONG%3E.%20Most%20of%20the%20Team%20update%20a%20worksheet%20held%20on%20a%20cloud%20server%2C%202%20have%20a%20master%20copy%20sent%20for%20them%20to%20download%20(Those%202%20then%20upload%20a%20renamed%20copy%20later).%3C%2FP%3E%3CP%3EWhen%20my%20user%20opens%20the%20updated%20document%20her%20colleagues%20have%20worked%20on%20she%20gets%20a%20'Errors%20were%20detected%20in%20file'%20error%20and%20the%20log%20shows%20that%20***.xml%20part%20was%20%3CREMOVED%3E%20and%20records%20from%20workbook%20properties%20are%20also%20removed.%20She%20doesn't%20see%20any%20of%20the%20updates%20that%20have%20been%20done%20to%20the%20file.%20Same%20with%20the%20copy%20from%20her%202%20other%20colleagues%20but%20the%20master%20copy%20can%20be%20retrieved%20and%20opens%20correctly.%3C%2FREMOVED%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20thinking%20this%20could%20be%20an%20issue%20either%20between%20the%20o365%20and%202016%20versions%20and%2For%2064-bit%20%2F%2032-bit.%3C%2FP%3E%3CP%3EI%20would%20be%20grateful%20if%20anyone%20has%20encountered%20this%20before%20and%20could%20confirm%20this%20as%20something%20I%20can%20work%20from.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1474393%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1474440%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Version%20Compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1474440%22%20slang%3D%22en-US%22%3ECan%20you%20get%20that%20user%20to%20edit%20the%20file%20using%20Excel%20in%20the%20browser%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1477281%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Version%20Compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477281%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20comment.%20I%20am%20in%20the%20process%20of%20trying%20to%20get%20her%20to%20attempt%20that%20and%20also%20to%20send%20me%20a%20copy%20of%20the%20problem%20workbook%20to%20test.%20I%20will%20update%20my%20post%20when%20I%20get%20more%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480719%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Version%20Compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480719%22%20slang%3D%22en-US%22%3E%3CP%3EReceived%20excel%20workbook%20copy%20for%20testing.%3C%2FP%3E%3CP%3EOpened%20in%2032-bit%20Office%202016.%3C%2FP%3E%3CP%3EEncountered%20error%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CambridgeIT_0-1592828817107.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200026iBFF2DBBE16350790%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22CambridgeIT_0-1592828817107.png%22%20alt%3D%22CambridgeIT_0-1592828817107.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERepair%20removes%20.xml%20part%20relating%20to%20PivotTable%20but%20there%20is%20no%20PivotTable%20defined%20on%20the%20sheets.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CambridgeIT_1-1592828985932.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200027i8DB0073ABD211866%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22CambridgeIT_1-1592828985932.png%22%20alt%3D%22CambridgeIT_1-1592828985932.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAttempted%20to%20open%20in%20o365%20Excel%20web%20version%20but%20cannot%20as%20file%20is%20encrypted.%3C%2FP%3E%3CP%3EStill%20unable%20to%20define%20a%20root%20cause%20for%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486108%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Version%20Compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486108%22%20slang%3D%22en-US%22%3EI%20am%20willing%20to%20take%20a%20look%20if%20you%20can%20send%20the%20file%20to%20me%20(and%20the%20associated%20file%20open%20password).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486129%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Version%20Compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486129%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThank%20you%20Jan%2C%20a%20kind%20offer%2C%20but%20I%20cannot%20do%20that%20for%20security%20reasons%20(the%20file%20holds%20financial%20data).%20A%20solution%20has%20not%20been%20found%20but%20the%20issue%20only%20arises%20during%20frequent%20shared%20use.%20Currently%20it%20is%20working%20and%20the%20user%20has%20requested%20we%20close%20the%20ticket.%3C%2FP%3E%3CP%3EI%20intend%20to%20close%20this%20conversation...%20when%20I%20can%20find%20out%20how.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to support a user who works with o365 Excel 64-bit. She has a worksheet shared with a team who all use Excel 2016 32-bit. Most of the Team update a worksheet held on a cloud server, 2 have a master copy sent for them to download (Those 2 then upload a renamed copy later).

When my user opens the updated document her colleagues have worked on she gets a 'Errors were detected in file' error and the log shows that ***.xml part was <removed> and records from workbook properties are also removed. She doesn't see any of the updates that have been done to the file. Same with the copy from her 2 other colleagues but the master copy can be retrieved and opens correctly.

 

I'm thinking this could be an issue either between the o365 and 2016 versions and/or 64-bit / 32-bit.

I would be grateful if anyone has encountered this before and could confirm this as something I can work from.

5 Replies
Can you get that user to edit the file using Excel in the browser?

@Jan Karel Pieterse Thank you for your comment. I am in the process of trying to get her to attempt that and also to send me a copy of the problem workbook to test. I will update my post when I get more data.

Received excel workbook copy for testing.

Opened in 32-bit Office 2016.

Encountered error 

CambridgeIT_0-1592828817107.png

Repair removes .xml part relating to PivotTable but there is no PivotTable defined on the sheets.

CambridgeIT_1-1592828985932.png

Attempted to open in o365 Excel web version but cannot as file is encrypted.

Still unable to define a root cause for the issue.

I am willing to take a look if you can send the file to me (and the associated file open password).
Best Response confirmed by Jan Karel Pieterse (MVP)
Solution

@Jan Karel Pieterse Thank you Jan, a kind offer, but I cannot do that for security reasons (the file holds financial data). A solution has not been found but the issue only arises during frequent shared use. Currently it is working and the user has requested we close the ticket.

I intend to close this conversation... when I can find out how.