|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
07-31-2008, 08:18 PM
|
|||
|
|||
|
Data missing, new panel appears above sheet.
Hi All,
I'm hoping this is something new to Excel 2007 or something simple and obvious that I've overlooked. I have spent a LOT of time compiling a list of emails and who their recipients are. A simple two column list. After saving and closing this list, I later went to re-open the list and found that a big chunk of the data had disappeared and some strange new panel had appeared at the top of the sheet. See image below...  Can someone please tell me what happened here?!! Have I unknowingly bumped a key, or checked the "screw-everything-up-on-save" box? If so, can this data be restored?! Any help is very much appreciated. Thanks! 
|
|
#2
08-01-2008, 07:28 PM
|
||||
|
||||
|
All you have done is grouped and outlined data!
Go to DATA then Ungroup and remove outline!
__________________
Regards, Simon Please read this before cross posting! Please always give feedback...good or bad! Please take the time to read the Forum Rules before posting!
|
|
#3
08-05-2008, 11:10 PM
|
|||
|
|||
|
Thanks Simon!
That gets rid of the group outline. I don't know what happened to all my missing data though. I guess it stands to reason that if I can accidentally group some data then I can just as easily delete a bunch of data! I thought perhaps these things would be related and perhaps all of my data would appear again after I ungrouped and removed outline. No such luck! Cheers Stanbridge
|
|
#4
08-06-2008, 04:45 AM
|
||||
|
||||
|
Grouping data should not delete it.
__________________
Hope that helps. RoyUK -------- For Excel consulting, free examples and tutorials visit my site Check out the free Excel Toolbar New members please read & follow the Forum Rules Remember to mark your questions Solved and rate the answer(s) Where to copy the code to Code Tags: Make your code easier for us to read
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
