And don’t even try to do a conversion of text to numbers in a big column. There’s a super fast way (name is eluding me) but if you respond to the error popup I imagine it looks at each cell of text, thinks says, “abracadabra you’re now a number!” for every row. It takes that long
Excel: taking ages to load a file
Excel: There is a link to another Excel document, but I can’t access it to update the value.
Me: Where?
Excel: To this document.
Me: … Where can I find the cell that contains this link?
Excel: I don’t know noises
Me: What if it is a named variable?
Excel: Yes.
And don’t even try to do a conversion of text to numbers in a big column. There’s a super fast way (name is eluding me) but if you respond to the error popup I imagine it looks at each cell of text, thinks says, “abracadabra you’re now a number!” for every row. It takes that long