Just make sure when pieces get taken you drag them under the board instead of deleting them. Otherwise what will you do when you need to promote a pawn?

i couldnt excel in chess, so decided to chess in excel

I promote my pawn to pivot table