So. Let's say I have a formula vlooking up A1 in an alternate sheet and trying to return whatever value. The formula is simple and correct.
The issue is that the formula doesn't work until I double click A1 and then enter which activates the cell to be used? Very weird behavior.
Please let me know if you've experienced this before and how to correct it in bulk since it's currently impacting 1000 or so cells.
The issue is that the formula doesn't work until I double click A1 and then enter which activates the cell to be used? Very weird behavior.
Please let me know if you've experienced this before and how to correct it in bulk since it's currently impacting 1000 or so cells.