Increase the max tokens parameter or edit your request to fit the token limit
Tokens limitation is reached
Each request to Open AI has a token limit. You can think of tokens as pieces of words, whereas 1,000 tokens are about 750 words in English. This paragraph is about 39 tokens.
To solve this issue, you can: A. Increase the Max Tokens parameter B. Use another model C. Edit your request (for Chat)
A. Increase the Max Tokens parameter
By default, Max Tokens are 3000 tokens. You can increase this value.
B. Use another model
You can choose a more advanced model: gpt-4 or gpt-3.5-turbo 32K. Don't forget to increase Max Tokens also.
C. Edit your request (also, for Chat)
If your request uses a lot of data, try to remove it. Also, you can add "Be short" to the Additional Instructions parameter or the end of your message.
If you are asking about a selected range, make the selection much smaller.
How to open the formula in the visual editor?
To edit those parameters in the visual editor:
Select the Cell with the formula → Go to the Actions tab in Sidebar → Click Edit Formula
