|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
05-25-2018, 03:04 AM
|
|||
|
|||
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
05-25-2018, 03:08 AM
|
|||
|
|||
|
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 |
Windows 7 32bit 
Office 2013
Linear Mode
