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/454094-re-trapped-cell.html)

[email protected] May 19th 18 02:02 PM

Trapped in a cell!
 
On Wednesday, October 23, 2002 at 11:31:10 AM UTC+5:30, 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.


Thanks James.....I too got stuck and i guess how frustrating it can get!!!


All times are GMT +1. The time now is 02:26 PM.

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