Making Code Backwards-Compatible for 2003

[cscribner]

I've built some sweet dashboards in Excel 2007, but the client is getting errors. I don't have a copy of v2003 (my computer came with 2007 pre-installed), so I'm wondering how people do this kind of testing to make things work in previous versions of Excel.

Do I need to buy a separate license of Excel to get the old version & install it? Is there a service where people can upload code and see what it does on that older version?

thanks,
Craig

 

[Trevor G]

Have you been told what isn't working based on your code and do you know what isn't working?

Any code snipets might help resolve this.

Have you looked also if any new formula available in 2007 is being used in your version, things like SUMIFS or COUNTIFS

 

[Norie]

Craig

Usually the thing to do is to test in the earliest version that's going to be used.

How you do that really depends on your setup.

Perhaps investing in a licence wouldn't be a good idea.

Otherwise you can always just try and avoid using anything that's specific the the version you are working in.