The formula set in Excel cannot be generated automatically. You must double-click the formula and press Enter to display the result

Reported answer
The formula set in Excel cannot be generated automatically. You must double-click the formula and press Enter to display the result
Ask online customer service
Scan the code to ask online customer service
  • Number of answers

    four

  • Number of browses

    8,959

4 answers Default sorting
  • Default sorting
  • Sort by time

According to your description, I can provide the following suggestions: First, you should check whether the auto complete function is set in Excel. If the auto complete function is enabled, the formula may not display normally. In addition, you can try refreshing the cell or re opening the Excel file to solve the problem. If none of the above methods works, you can also consider contacting the official technical support of Excel for help. They will provide more professional guidance and solutions.
cancel comment
Try the following
Select the column where the formula is located, and then click Data Column Complete.
cancel comment
It is possible that your formula is copied, and the original cell setting is text format
Also, you have not turned on automatic recalculation in the option ->formula
cancel comment
After looking at other methods, my situation is not "[Data - Sorting - Completion]" as mentioned in the above comment.
I set it like this in "Tools" (in WPS, it is "File") - "Options" - "Recalculate" - "Auto Recalculate"..
cancel comment
ZOL Q&A > The formula set in Excel cannot be generated automatically. You must double-click the formula and press Enter to display the result

report

Thank you for contributing to the harmony of the community. Please select the type of report

Reported successfully

It will be handled after verification
Thank you for your contribution to community harmony

Scan the code to participate in the trial of new products at 0 yuan
You can get the sheets and grand gifts on the top floor

 Scan and pay attention to us
Tips

Are you sure you want to cancel this registration and exit this activity?