What should I do if excel keeps prompting that the reference is invalid? |
您所在的位置:网站首页 › excel去除公式无效数据怎么弄出来 › What should I do if excel keeps prompting that the reference is invalid? |
Excel keeps prompting that the reference is invalid. Solution: First press the keyboard shortcut [ctrl alt delete] to open the task manager; then select the excel process and click the End Task button; finally right-click the window and select Close Task Manager. The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer. Excel keeps prompting that the reference is invalid Solution: 1. After inserting the control, the design mode cannot be selected and the interface cannot be clicked. #2. An invalid reference prompt pops up and the software cannot be closed, as shown in the figure below. #3. At this time, you can press the keyboard shortcut ctrl alt delete to open the task manager. #4. Select the excel process and click the End Task button. 5. Right-click the window and select Close Task Manager. #6. Double-click the excel shortcut again to open the software. #7. As shown in the figure below, the control will be deleted when opened again, and the prompt box will no longer pop up. The above is the detailed content of What should I do if excel keeps prompting that the reference is invalid?. For more information, please follow other related articles on the PHP Chinese website! |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |