Soring creates #Ref - VERY UNIQUE PROBLEM

hdalebennett

New Member
Joined
Nov 5, 2018
Messages
1
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
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,111
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,129,317
Messages
5,635,527
Members
416,862
Latest member
MGDlite

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top