Issues about cell reference in formulas and large formulas edition.
I was working here in a spreadsheet that contains a range with like 50 cells filled with quite large formulas, and all formulas uses, by more than one time a reference to cell $Q$1 that shall contain an integer number.
Problem is, it is a requinted layout and I need to make a simples small chage where I deleted Q column and then the new $Q$1 cell had a text on it, wich was previously the R1 cell. Naturaly all the formulas got an error, of course. But when changed the value of Q1 to a integer number I noticed the formulas does not worked anymore. By inspectioning this I found the $Q$1 reference in formulas was all replaced with this string "#REF!".
Luckly I had saved before doing the layout changes, if not it would e painful to fix.
By killing two rabits with one shot. Editing large formulas in Excel 2016 can be very bad due to lack of a large text box to do so, and even more because when you reach the right limit it forward all the characters left like changing a page. I'm using notepad to help with complex formulas here.
Thank you for your time.