Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Excel to Numbers conversion: Finding Unsupported Formulas

When importing Excel spreadsheets into Numbers, I sometimes get:

"Unsupported formulas were replaced by the last calculated value."

"Some formulas couldn't be imported. Last values were retained."


Is there any way to find What formulas were unsupported and in Which cells they reside?

That would make switching over to Numbers much much easier.

MacBook Pro 13”, 10.14

Posted on Feb 8, 2019 9:12 AM

Reply
Question marked as Apple recommended
Is there any way to find What formulas were unsupported and in Which cells they reside?


After you've opened an Excel spreadsheet with Numbers, have you looked for the blue warning triangles in the cells containing unsupported formulas?



These tell you which cells contain unsupported formulas.


SG

Posted on Feb 9, 2019 2:43 PM

3 replies

Feb 8, 2019 10:52 AM in response to DrDPH

I don't know of any way to identify them after opening in numbers, however, If you can get an export from excel of the formulas used, you could then compare to the functions list for numbers posted here. anything missing is your group you are looking for.


to get the formulas you can either

a) write a vba script to go through all populated cells and pull them out to a text file (if there are lots of them)

b) Type Ctrl ~ to see formulas, then copy them out to a text editor (If not too many)


edit: I just made a new tip (screwed up the title should be excel v numbers, not numbers v numbers )based on this as i couldn't find a list of "missing formulas", and i have seen this kind of question many times before. I dont know if this is a permanent link , or where the tips show up, but here is the one i got after creating it today:

https://discussions.apple.com/docs/DOC-250000546



Jason


Question marked as Apple recommended

Feb 9, 2019 2:43 PM in response to DrDPH

Is there any way to find What formulas were unsupported and in Which cells they reside?


After you've opened an Excel spreadsheet with Numbers, have you looked for the blue warning triangles in the cells containing unsupported formulas?



These tell you which cells contain unsupported formulas.


SG

Excel to Numbers conversion: Finding Unsupported Formulas

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.