Sort function introduces errors

Question

See excel file at this Dropbox link.

References in equations are not sorted properly if there is a TAB REF prefix to a cell local to the current tab.

Excel Bug.xlsx

Answer 1

I do not intentionally use a same sheet reference. I create the formula by clicking cells - first on a cell on another sheet and then on a cell local to the formula cell:

1. select cell
2. type =
3. go to another sheet and select a cell with a value
4. go back to the original sheet and select a cell with a value - this becomes a same sheet reference.

Answer 2

Hi JoeMarkee,

If you get unexpected results when sorting your data, check to see if the values returned by a formula have changed. If the data that you have sorted contains one or more formulas, the return values of those formulas might change when the worksheet is recalculated. In this case, make sure that you reapply the sort to get up-to-date results.

Reference:  Under section Learn more about general issues with sorting in Sort data in a range or table

Regards,

Neha

Answer 3

Hi JoeMarkee,

Thanks for the workbook.

Please allow me some time, I'll check the workbook to find the cause. I'll update you when I have the information.

Regards,

Neha

Answer 4

See OneDrive folder

Answer 5

Hi JoeMarkee,

I am unable to open your Excel workbook, as Dropbox is asking me to sign in. Could you please provide the link again? Alternatively, you can upload your workbook in the following OneDrive link.

OneDrive link

Note: Please do not include any personal information such as full names, email id etc. in your workbook.

Thanks,

Neha