Soring creates #Ref - VERY UNIQUE PROBLEM

[hdalebennett]

I have used Excel for over 30 years and have never encountered this problem. When I sort, it tells me that I have a circulation issue (which I do not). It also says there could be a problem with WK1
(whatever the heck that is)
Trying to read about WK1 was very limited and even mentioned something about Lotus 123 which I have never used.
It seems there is some kind of corruption issue and I have attempted to re-create the spreadsheet in an entirely new file – but it still creates the same scenarios.
Can I send my file to you for your review? This is an extremely important project regarding "world hunger". Not being able to sort is hampering me greatly.
Regards,
Dale Bennett

 

[Michael M]

You can upload the file to a share site like dropbox, then post the link back here.
A REF error usually means the formula is referring to a cell / sheet that doesn't exist or isn't valid !
So, for instance, if your formula refered to a cell 2 rows up and when you sorted the data, that formula was in row 1....it would give a REF