Forum Discussion
#spill error may be linked to named references and formatting
Excel is issuing #spill! Error messages in one of my worksheets. Most of the articles I read suggested that this error often originates From the use of cell merges, which I use extensively. My m...
Thank you for responding.
I don't think you are understanding my dellima
The calculations work with R1C1 references.
The calculations do NOT work with Named References.
The error, #spill!, occurs only when Named References are used when at least one of the cell values is referenced by names. The error seems unpredictable.
The article you suggested I read does not appear to even hint of the above
condition as being a cause of the error.
The subtypes of #spill! error ARE indicated.
1) "A cell we need to spill data into is not blank."...which is not my case.
2) "We can't spill into a merged cell". That IS the case but only if I use named references. for the exact same merged cells, i don't get the error, "we can't spill into a merged cell" if i use R1C1 referencing.
That is why I posted the question. This issue does not appear to be addressed anywhere.
It would be nice ifi this forum allowed one at attach a worksheet or segment of a worksheet.
I don't think you are understanding my dellima
The calculations work with R1C1 references.
The calculations do NOT work with Named References.
The error, #spill!, occurs only when Named References are used when at least one of the cell values is referenced by names. The error seems unpredictable.
The article you suggested I read does not appear to even hint of the above
condition as being a cause of the error.
The subtypes of #spill! error ARE indicated.
1) "A cell we need to spill data into is not blank."...which is not my case.
2) "We can't spill into a merged cell". That IS the case but only if I use named references. for the exact same merged cells, i don't get the error, "we can't spill into a merged cell" if i use R1C1 referencing.
That is why I posted the question. This issue does not appear to be addressed anywhere.
It would be nice ifi this forum allowed one at attach a worksheet or segment of a worksheet.
- Thank you Detlef!
I tried dragging my file into the full text editor. The editor refused to accept the file type of XLSX. I did copy the cells from the worksheet but the copied result does not allow you to see the formulas so YOU guys can test out the formulas. It appears to be just a static snapshot of my worksheet range of interest