Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trapped in a cell!
On Wednesday, October 23, 2002 at 11:22:07 AM UTC+4, Jeff Mathews wrote:
Hello Hudan. Press Escape. This should abort your changes. Jeff Mathews, Excel 97 on NT 4 in Luxembourg -----Original Message----- After creating a data table, I double clicked into a cell and deleted its contents. When I pressed enter, the message came up saying "cannot change part of a table". After some panic button smashing, I am now unable to recover the original formula of the cell (I can only undo, redo the last thing I typed in there). Now I cannot get out of the cell, go to anoter sheet or even quit excel without recovering the original formula. Please help. Thanks. . You just saved my life. Didnt save 2 hours of work and this happened..... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trapped in a cell!
On Saturday, May 7, 2016 at 12:56:44 PM UTC-4, wrote:
On Wednesday, October 23, 2002 at 11:22:07 AM UTC+4, Jeff Mathews wrote: Hello Hudan. Press Escape. This should abort your changes. Jeff Mathews, Excel 97 on NT 4 in Luxembourg -----Original Message----- After creating a data table, I double clicked into a cell and deleted its contents. When I pressed enter, the message came up saying "cannot change part of a table". After some panic button smashing, I am now unable to recover the original formula of the cell (I can only undo, redo the last thing I typed in there). Now I cannot get out of the cell, go to anoter sheet or even quit excel without recovering the original formula. Please help. Thanks. . You just saved my life. Didnt save 2 hours of work and this happened..... Whoever posted this! Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trapped in a cell! | Excel Discussion (Misc queries) | |||
Can run-time 1004 be trapped ? | Excel Programming | |||
Can run-time 1004 be trapped ? | Excel Programming | |||
Error not trapped - please help!!! | Excel Programming | |||
Can error 1004 be trapped???? | Excel Programming |