If you insert  a gif  as a picture it will not play.

If you use

Insert/Object/Create from file/
Then browse to your object
Then click OK

You will end up with an icon in your spreadsheet. When you double click the
icon and click Yes to the OLE warning your .gif will play.