I like the idea of using ChatGPT in Excel, but unfortunately, no Add-Ins are allowed in my MS Excel (My Add-ins and Get Add-ins are disabled, as well as all other options in the Add-ins tab). But I didn’t give up, and below, I will describe how to use ChatGPT in a similar situation.
MS Excel allows the addition of some scripting to your spreadsheet, which is a really great feature I like to use, but by default, it is hidden in the menu. So, first of all, you should enable the Developer option as shown in the screenshot below. To open this dialog, follow this path: File > Options > Customize Ribbon.
The “Developer” tab will appear once you add it to the main tabs, and then you can go to Excel Add-ins.
Then press the ‘Browse’ button and choose the askforumai.xla file. This file contains only VBA macros, and you can check that it doesn’t contain anything dangerous if you open it using the “Visual Basic” button.
The source of this script is available at GitHub and you just need to download it and start using.
So now you can use this macros using simple formula =AskForumAI(<your prompt>, <your chat gpt key>)
I would appreciate it if you could let me know whether this approach has been useful for you, or if you have any suggestions for improvement.