Forum Discussion
Error when opening workbook
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 fil...
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
I only use 1 or 2 custom sorts in tables.
You gave me a lead on the issues to try and address.
Ty