View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] clarkpjer13@bigpond.com is offline
external usenet poster
 
Posts: 1
Default 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