This has to be a simple solution that I'm missing.
I have two tabs. Tab 1 reads Tab 2.
I have sorted data in Tab 2 and Tab 1 reads it.
I changed the sort order on Tab 2, but Tab 1 still shows the old sort.
This is a general formula and not a macro.
Automatic calculations are on (although I realize it's not a calc, per se)
The only way to get Tab 1 to reflect the new sort on Tab 2 is to go into each cell (there are approx. 800 rows and 32 columns) and repeatedly press F2 and then <Enter>. Yes, I can survive a few cells of this. But to have to manually do this to more than 25,000 cells is unworkable.
Any ideas on how to fix this? I have no idea what is going on. I had this issue about 20 years ago but for about 30 rows, I was manually hitting F2+ Enter to solve quickly. Changing format doesn't seem to work and each sheet is set to the same format for each sheet entirely.
What's going on? Any workarounds?
Thanks in advance for any guidance.
I have two tabs. Tab 1 reads Tab 2.
I have sorted data in Tab 2 and Tab 1 reads it.
I changed the sort order on Tab 2, but Tab 1 still shows the old sort.
This is a general formula and not a macro.
Automatic calculations are on (although I realize it's not a calc, per se)
The only way to get Tab 1 to reflect the new sort on Tab 2 is to go into each cell (there are approx. 800 rows and 32 columns) and repeatedly press F2 and then <Enter>. Yes, I can survive a few cells of this. But to have to manually do this to more than 25,000 cells is unworkable.
Any ideas on how to fix this? I have no idea what is going on. I had this issue about 20 years ago but for about 30 rows, I was manually hitting F2+ Enter to solve quickly. Changing format doesn't seem to work and each sheet is set to the same format for each sheet entirely.
What's going on? Any workarounds?
Thanks in advance for any guidance.