Forum Discussion
Excel 365 "If" function "Name" definition Spill error
Excel 2016 and prior I would use the Name of headings and refer to this when going to the "IF" function to give a result to the if EQ question. Using same process in 365 get "#SPILL" error. How do ...
Sorry for typographical error....i am not a "Pro"
I use the @Name function to identify a range that has desired text and it is in the top row (AA1:AZ1) and call that range "Bike"
Below this row I use the @IF function to read a cell in row 2 and if "True" read the top row (1) and give me the "text" value in the "Bike" named range for that column. If argument is "False" load a "|" character so I can replace with " " later after pasting value. Spill# fills in the row as soon as I enter the first function and populated the whole row to the right (shaded)
It worked fine in Excel 2016 never saw #Spill until 365. How do I disable #Spill?
Thanks
I use the @Name function to identify a range that has desired text and it is in the top row (AA1:AZ1) and call that range "Bike"
Below this row I use the @IF function to read a cell in row 2 and if "True" read the top row (1) and give me the "text" value in the "Bike" named range for that column. If argument is "False" load a "|" character so I can replace with " " later after pasting value. Spill# fills in the row as soon as I enter the first function and populated the whole row to the right (shaded)
It worked fine in Excel 2016 never saw #Spill until 365. How do I disable #Spill?
Thanks
Perhaps you may share if not file when couple of screenshots ?
That how 365 works, but I don't know how to explain what to do without sample, we use different terminology.