Insert gif files into spreadsheet

Question

Hi,I have inserted a gif file into my spreadsheet just as I would any other picture format. The animation does not play once inserted. I am using Exce 2016.It there a way to get the animation to work once the file is embedded into the spreadsheet?

forrest1210 · Answer

I am still trying to make gif files work in excel 2016. I have them inserted on an object (Shape that I created as a "viewscreen"), not in a cell. I have tried a solution from the techwalla website but can't make it work. I have included a screen print of the instructions and what I have done, including the VB error message. I believe that I followed the instructions correctly. Can anyone help?&nbsp;I opened "Design Mode" on my own because the method in the instructions, the commands listed in the steps, are not found in my menus. Because of that, I still can't complete step 5, "Open the Microsoft Web Browser used to view &amp; control the gifs". (Opening Edge or Internet Explorer doesn't seem to help anything.)&nbsp;

sergeibaklan · Answer

Please check
https://www.techwalla.com/articles/how-to-insert-animated-gif-files-in-excel
https://tanaikech.github.io/2017/06/06/embedding-animation-gif-in-a-cell-on-spreadsheet/
&nbsp;
&nbsp;

forrest1210 · Answer

Thanks for the answer. It looked promising, but I can't do the following 3 steps in the https://www.techwalla.com/articles/how-to-insert-animated-gif-files-in-excel article. I do not have the "Toolbars" option on my "View" menu and can't find it to add it from the customize ribbon option in Excel 2016, or in any other menu location.The "Design Mode" is located on the "Developer" tab menu so I do have that. I found a "Control Toolbox" in the Visual Basic menus, but it is greyed out and I can't open it.

Step

Click on the "View" menu and choose "Toolbars" => "Control Toolbox."

Step

Click on the top button in the "Control Toolbox," which activates "Design Mode." "Design Mode" allows you to draw an item in your spreadsheet that may receive an object such as an animated GIF.

Step

Click on the bottom button in the "Control Toolbox," which has a hammer. From the drop-down menu, select "Microsoft Web Browser." This activates "Microsoft Web Browser" controls, which can be used to view animated GIFs.

sergeibaklan · Answer

I didn't play with this, but in general&nbsp;
File-&gt;Options-&gt;Customise Ribbon and be sure Developer checked.
Controls are under Developer tab on ribbon

forrest1210 · Answer

I do not have the options listed in the instructions below to follow them. The view tab and developer tab are active in Excel 2016, but there is no "Toolbars",&nbsp;"Control Toolbox," or a&nbsp;drop-down menu from it to select "Microsoft Web Browser" OR&nbsp;the bottom button in the "control box", where the dirrections list the hammer. Screen prints attached.StepClick on the "View" menu and choose "Toolbars" =&gt; "Control Toolbox."&nbsp;StepClick on the top button in the "Control Toolbox," which activates "Design Mode." "Design Mode" allows you to draw an item in your spreadsheet that may receive an object such as an animated GIF.StepClick on the bottom button in the "Control Toolbox," which has a hammer. From the drop-down menu, select "Microsoft Web Browser." This activates "Microsoft Web Browser" controls, which can be used to view animated GIFs.

Forum Discussion

Insert gif files into spreadsheet

7 Replies

Step

Step

Step

Resources