Forum Discussion

Copper Contributor

Jun 01, 2023

Sorting Excel Table doesnt sort the non-table data; Query autofills manually edited cells with formu

Hi, I'm using Query to automatically update my data from A to D (Consider D header to be Category)columns. I have a column on E whose formula is basically =Table_Categorizer[@Category] Proble...

office 365

Rohan110

Copper Contributor

Jun 11, 2023

Lorenzo

Hi tried the above method but it still doesnt work.

The first cell in the Manually changed category has the formula =[@Category]. So every time i refresh, the eating out value changes to the above formula.

Lorenzo

Silver Contributor

Jun 11, 2023

Hi Rohan110

As I understand you want to make exception(s) to the "rule" (=[@Category]). AFAIK this isn't reliably possible. Unchecking "Preserve column sort/filter/layout" (in Data > Properties) has some effects...