|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula shows the same value in all cells instead of updating as per forumla...
When I try to drag this formula to get the column updated with this formula in cell, it is just copying the same date in all cells. But whenever I double-click on any cell it is get updated. The columns AA2 & P2 formatted as date (28-May-2018) =IF(AA2<>"",AA2,P2) Please support. |
#2
|
|||
|
|||
Got it. The following tip is working fine.
2010 and newer: File > Options > Formulas > Workbook Calculation > Automatic. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cells not updating | jalea148 | Excel | 3 | 12-16-2017 01:01 PM |
how to shows cells range depending on dropdown menu value | mfran2002 | Excel | 5 | 10-26-2017 08:08 AM |
Need forumla for percentage | mquillen | Excel | 5 | 02-06-2017 08:59 AM |
how to get formula to work that shows a - when the answer should be 0 | c0sm0s | Excel | 5 | 09-28-2016 06:08 AM |
Linked excel cells not updating in word | lucky16 | Word | 0 | 09-10-2014 07:40 AM |