|
|
#2
07-22-2015, 11:53 PM
|
||||
|
||||
Yup, that's how it works...
If you need to sort on such results, try copying & using paste special to turn them into values, then sorting on the column with the values rather than the one with the formulae.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
| Updating document causes change lines on all cross references. :( | garybeck | Word | 2 | 05-08-2015 09:15 PM |
| Macro to change cell references | SaneMan | Excel Programming | 6 | 10-01-2013 02:49 PM |
| Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |
| quick replace, sort, change columns | userman | Excel | 1 | 05-01-2012 06:24 AM |
Cell references don't change on sort
Windows 7 64bit 
Office 2010 32bit
Threaded Mode