Error when opening workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2936676%22%20slang%3D%22en-US%22%3EError%20when%20opening%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2936676%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20the%20past%20several%20months%20I've%20gotten%20the%20following%20error%20(see%20image)%20the%20excel%20has%20removed%20the%20the%20following%20table.%20I've%20called%20support%20and%20they're%20answers%20was%20to%20do%20a%20file%20save%20as%20or%20save%20the%20file%20to%20local%20computer%20the%20upload%20to%20SharePoint.%20This%20doesn't%20work%2C%20because%20the%20problem%20will%20come%20back%20a%20day%2C2%20or%203%20later.%20Depending%20on%20my%20usage.%3C%2FP%3E%3CP%3EI%20can%20say%20I%20don't%20have%20any%20%22table29.xml%22%20in%20the%20workbook%2C%20because%20excel%20removed%20it%2C%20lol.%3C%2FP%3E%3CP%3ESo%20I%20cant%20even%20find%20the%20the%20table%20and%20even%20try%20to%20address%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20dont%20want%20to%20workaround%20the%20issue%2C%20I%20wish%20to%20address%20it%20and%20make%20it%20not%20happen%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2936676%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2937921%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20when%20opening%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2937921%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F903304%22%20target%3D%22_blank%22%3E%40Joe_H5550%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EThe%20error%20message%20from%20Excel%20actually%20says%20that%20the%20Sort%20records%20are%20getting%20removed%2C%20not%20the%20table%20itself.%20Perhaps%20the%20sort%20conditions%20this%20table%20relies%20on%20are%20not%20consistent%20anymore%20over%20time%20(header%20renaming%2C%20deletion%2C%20source%20refresh%2C%20...)%20so%20it%20raises%20an%20error.%20Of%20course%20this%20error%20does%20not%20pop%20up%20nicely%20so%20you%20can%20at%20least%20fix%20it%20in%20a%20timely%20manner.%3C%2FP%3E%3CP%3EThe%20suggestion%20I%20would%20have%20is%20to%20not%20rely%20on%20a%20custom%20sort%20on%20this%20table%2C%20or%20even%20on%20sorting%20at%20all.%3C%2FP%3E%3CP%3EHope%20it%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

For the past several months I've gotten the following error (see image) the excel has removed the the following table. I've called support and they're answers was to do a file save as or save the file to local computer the upload to SharePoint. This doesn't work, because the problem will come back a day,2 or 3 later. Depending on my usage.

I can say I don't have any "table29.xml" in the workbook, because excel removed it, lol.

So I cant even find the the table and even try to address the issue.

 

I dont want to workaround the issue, I wish to address it and make it not happen again!

2 Replies

@Joe_H5550 

Hello,

The error message from Excel actually says that the Sort records are getting removed, not the table itself. Perhaps the sort conditions this table relies on are not consistent anymore over time (header renaming, deletion, source refresh, ...) so it raises an error. Of course this error does not pop up nicely so you can at least fix it in a timely manner.

The suggestion I would have is to not rely on a custom sort on this table, or even on sorting at all.

Hope it helps.

 

Thanks Stephane
I only use 1 or 2 custom sorts in tables.
You gave me a lead on the issues to try and address.
Ty