2003/2010 compatibility

[mrjaffa]

Hey guys.

I've created a staffing rota in excel which I did years ago and have updated it over the years. I've made quite a few changes to it this year, adding quite a few formulas.

I did this at home using excel 2010, but I use it on excel 2003 at work, and every time I open it at work I get errors, which I think is due to it being in 2003 as it's fine at home, as it doesn't bring up any errors in 2010, but after using it at work it seems to have 'broken' some of the formula even in 2010.

The problem is, I can't download the excel compatibility pack at work as the computers have restrictions on them.

I realise I haven't included the error as I'm at home and can't remember it exactly, but just wondering if anyone has any ideas. I'm just on my iPhone right now but could attach the file if anyone wanted a look.

Thanks!

[oeldere]

If you use formula in excel 2010, that didn't exist in excel 2003, you get faillure in excel 2003.

e.g. sumifs, iferror

[MarvinP]

Here is a list showing some of the ones that are new and which version they showed up in.

http://www.computergaga.com/excel/functions/