#1   Report Post  
Posted to microsoft.public.excel.misc
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
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
How do I trapped the error and optimize the code? Jay Excel Programming 5 January 15th 09 06:20 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 03:55 PM


All times are GMT +1. The time now is 06:16 AM.

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

About Us

"It's about Microsoft Excel"