ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trapped in a cell! (https://www.excelbanter.com/excel-discussion-misc-queries/448828-re-trapped-cell.html)

[email protected]

Trapped in a cell!
 
On Wednesday, October 23, 2002 4:24:01 PM UTC+10, Hudan wrote:
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.


what a lifesaver - i was about to close everything and lose 3 hours of work FRUSTRATING and one last search found your Answer - should go to the top of the google search I say!!!!!! Thanks heaps


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com