bloody solver is just not doing what I want it to do - even the simplest task

okay : in cells A1:P16 (ie a 16x16 cell grid) I want integers between 1 and 16 inclusive

each row can only hold each number once

each column can only hold each number once

nothing I try, works. I'm using =MAX(FREQUENCY(A1:P1,A1:P1)) to make sure there's no repeats in each row, ditto with columns =MAX(FREQUENCY(A1:A16,A1:A16)) and am constraining each 32 formulae to equal 1. My target cell is set to a value of 1, it being the MAX value of all of the above FREQ formulae

I'm changing cells A1:P16, constraining them all to integers, >=1 and <=16

it don't work

if anyone can replicate such a "golden square" via solver, I'd appreciate it as I haven't a clue why mine's not working

(I don't want a manual answer, I can do this in about 2 minutes manually, nor do I want a VBA solution, I want to know why my solver isn't giving me what I want : I have also checked the helpfiles, poured through the SOLVSAMP.xls and have read the solver manufacturers' site)

any solver experts / users out there ?

ta

Chris