Array Formulas "N/A" When Opened in Excel 2013

[Remsai]

Hello,

I have a nice sheet full of Indirects and Index Matches.

I worked on it on Excel 2007.

However when I open it on my other PC, which has Excel 2013, all the formulas are "N/A".

Also when I open it on any PC that has Excel 2007 it works.

I've tried all solutions to fix N/A errors, however I just can't understand what the problem might be.

Is it a different way that Indirect or Index Match works in Excel 2013?

Thanks

 

[Aladin Akyurek]

If your non-vba formulas work in 2007, they will also work in 2013, the higher version.

 

[Remsai]

Then what might the problem be?

 

[Aladin Akyurek]

Then what might the problem be?

Run some diagnostic actions...

1. Try to open the file on a totally different machine with a 2013 Excel. Still #N/A?

2. Do the formulas refer to external workbooks?

 

[Remsai]

Run some diagnostic actions...

1. Try to open the file on a totally different machine with a 2013 Excel. Still #N/A?

2. Do the formulas refer to external workbooks?

Thanks.

It turned out to be the date format setting on the computer.

This computer was "mm-dd-yyyy" so I changed it to "dd-mm-yyyy".

Since the sheet was matching dates, this was important.

Thanks again