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.
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?
