Excel 2013 - problems readind formulas created with newer Excel files

[powerdrome]

Hello All,
I ask your support on this issue:
I often open excel files sent by cistomers/suppliers, etc... with formulas.
When I open those in my Excel 2013 the formulas are not working, and instead are wrapped by curly brackets {formula}
the formula is still there, but I have to go cell by cell, click F2+Enter and the formula automaticcaly delete brackets.
But with several tabs, and thousand of references it is impossible to make the file work.

Investigating on Google I found the issue could be related to new Excel suite incorporated Dynamyc Arrays, thus Excel 2013 is not reading formulas correctly.

Any Idea how to make excel 2013 read, or convert or correct?

Thanks a lot

[alansidman]

crossposted: https://www.mrexcel.com/board/thread...files.1174013/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

[powerdrome]

Thanks sorry

[Zaerick]

Sounds like it is an array. If that is the case you should just be able to press F2 and enter to remove the array.

[powerdrome]

Ok thanks, the problem is that there are hundreds of cells with arrays, also cross between 10 tabs, so making all the calculations and the file unusable.
How can I mofify those all at once?

[powerdrome]

bump... Hello All, sorry any other hint on this please?

[AliGW]

Not without seeing a sample workbook. There are instructions at the top of the page telling you how to attach one here.

[powerdrome]

Not without seeing a sample workbook. There are instructions at the top of the page telling you how to attach one here.

here it is thanks

[powerdrome]

hello all sorry i've uploaded the file, anyone get any hint please?

[josephteh]

I believe formulas with curly brackets are not the issue, it is those new formulas not recognised by your current version of Excel, those formulas with _xlfn prefix. Best bet is to upgrade your Excel version.

[powerdrome]

I believe formulas with curly brackets are not the issue, it is those new formulas not recognised by your current version of Excel, those formulas with _xlfn prefix. Best bet is to upgrade your Excel version.

ok thanks a lot