#1   Report Post  
Old May 7th 16, 05:56 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2016
Posts: 1
Default 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   Report Post  
Old June 6th 16, 12:10 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2016
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trapped in a cell! [email protected] Excel Discussion (Misc queries) 0 June 2nd 13 03:34 AM
Can run-time 1004 be trapped ? Tom Ogilvy Excel Programming 4 September 16th 04 02:31 PM
Can run-time 1004 be trapped ? BHARATH RAJAMANI Excel Programming 0 September 16th 04 11:31 AM
Error not trapped - please help!!! Bura Tino Excel Programming 8 April 18th 04 09:27 PM
Can error 1004 be trapped???? Richard m Excel Programming 3 November 29th 03 02:55 PM


All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017