Forum Discussion
Solved
"Cells without simple text were ignored"
Hi! I have just contacted Microsoft support, who directed me here. I am trying to create a custom list across colums so each cells value is linked with its adjacent cell i.e. A1 and B1, A2 a...
- Custom lists contain static values and apparently Excel does not like it if the cells containing the list have formulas in them. Your only workaround is to first create a static copy of the formulas (paste special values) and then import the list.
Thanks for the response!
Unfortunately none of the cells contain formulas :(
I'm linking an address ID (numerical) with and address in text?
Thanks again!
Dang I'm in the same boat. No formulas, just numbers. What on earth is going on?