Most Difficult MS Excel questions

[Coasti]

Another problem is auditors

OK, I see where you are coming from used to be one myself. But these days I make things as automated as possible and month ends are a breeze.

 

[Rkootknir]

get him to use the same forumla's that he created in the version of excel in an older version of excel.

because if you go back to the right version he will be in a position where all formula delimiters (like the separator in a vlookup) goes from a ; to a ,

if you really want to troll him let him create a vlookup onto a sheet sitting on a different file server (with a coma in the name(new versions of excel that can happen)
then move the forumla's over to a differnt machine using an older version of excel where the forula's are coma delimited and wathc his face when the forumla no longer works.

I actually went through that when handing over a report.
I am on Win 7 with excel 2010 (coma delimited formula)
new guy is on win 8.1 with office 2013 (semicolon delimited formula)
both of us are 64 bit.
just you know, if you want to explore before testing

In older versions of Excel (prior to around 2007 IIRC) the Excel list separators were set in the application itself and the default was a comma.

In newer versions the list separator default in Excel is now set as the one defined in the operating system (i.e. in the "Region" Control Panel applet for Windows). You can verify this in Excel options for the newer versions - under the Advanced tab the "Use system separators" checkbox is on by default.