Forum Discussion
Excel automatically changing relative reference to text
I have several Excel files that have relative references within one sheet to data entry fields in other sheets within the same Excel file. Lately, the relative references within cells get converted ...
did you try to use the INDIRECT function to use text as references
Ramiz_Assaf Thanks, but no, I'm trying to find out why it's all of the sudden happening and preventing it. There is no reason for Excel to convert the referenced data to permanent text (and remove the embedded cell references) unless some setting has changed I'm unaware of.
