Excel for mac 15.23 why won't formulas work

broken image

Nothing incredibly fancy but it works fine on my computer. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations. I've written a macro that is relatively simple.

broken image

I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise.