Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Macro deleted ALL data!!

I ran a macro in Excel 2007 and it deleted all of my data. I cannot find a
way to restore the deleted data. Any suggestions?????
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Macro deleted ALL data!!

Well, if you have not saved that version of the file, then just close
it without saving, and your original file will still be there.

Hope this helps.

Pete

On Aug 6, 3:53*pm, Angel the Secretary <Angel the
wrote:
I ran a macro in Excel 2007 and it deleted all of my data. *I cannot find a
way to restore the deleted data. *Any suggestions?????


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Macro deleted ALL data!!

Do you have a backup?

Does your IT department backup files for you?

Have you emailed it to someone else--check your sent folder or ask for a copy
back.



Angel the Secretary wrote:

I ran a macro in Excel 2007 and it deleted all of my data. I cannot find a
way to restore the deleted data. Any suggestions?????


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Macro deleted ALL data!!

Close, BUT DO NOT SAVE THE FILE. Reopen it and all your data will be there.

Angel the Secretary wrote:

I ran a macro in Excel 2007 and it deleted all of my data. I cannot find a
way to restore the deleted data. Any suggestions?????


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 348
Default Macro deleted ALL data!!

Bob I wrote:
Close, BUT DO NOT SAVE THE FILE. Reopen it and all your data will be there.

Angel the Secretary wrote:

I ran a macro in Excel 2007 and it deleted all of my data. I cannot
find a way to restore the deleted data. Any suggestions?????


and once you get the data back, delete the macro! It's dangerous...

Bill
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
Pivot Table Data-Deleted Data still appears CrimsonPlague29 Excel Discussion (Misc queries) 8 January 18th 08 05:52 PM
Deleted Data Clare Excel Discussion (Misc queries) 2 December 13th 06 11:15 AM
If No is deleted in middle of sequence,Nos alter after deleted No crusty53 New Users to Excel 3 June 20th 06 09:50 AM
How do I delete checkboxes from rows I deleted in a macro? Jazzi-D Excel Discussion (Misc queries) 1 January 18th 06 12:49 AM
Macro Deleted Jean-Francois Excel Discussion (Misc queries) 1 January 12th 05 03:12 PM


All times are GMT +1. The time now is 05:15 PM.

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

About Us

"It's about Microsoft Excel"