#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default EXCEL SHEETS

Can you reinstate deleted sheets in excel, if so how please. thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default EXCEL SHEETS

If you haven't saved the workbook, you could save the current version as a new
name. Reopen the original worksheet and copy/move it into the current workbook.

Depending on formulas/links, you may have some fixing to do, though.

Daisy wrote:

Can you reinstate deleted sheets in excel, if so how please. thanks


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default EXCEL SHEETS

Only from a backup of the workbook.

The warning message given when you delete a sheet is meant to make you pause
and reflect on the consequences of that deletion.

There is no "undo" for that action.


Gord Dibben MS Excel MVP

On Fri, 16 Jan 2009 17:40:03 -0800, Daisy
wrote:

Can you reinstate deleted sheets in excel, if so how please. thanks


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default EXCEL SHEETS

No, deletion is permanent - that's why you get a warning message.

If you have not saved the file with its original name, though, you can
use File | Save As to save the current file with a different name, and
then the original one can be opened (with the sheet still in it).

Hope this helps.

Pete

On Jan 17, 1:40*am, Daisy wrote:
Can you reinstate deleted sheets in excel, if so how please. thanks


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default EXCEL SHEETS

I should have mentioned that if you have not yet saved the workbook, close
it without saving and your sheet(s) will not be lost.

Maybe some recent work but that's all will be lost.


Gord

On Fri, 16 Jan 2009 17:58:35 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Only from a backup of the workbook.

The warning message given when you delete a sheet is meant to make you pause
and reflect on the consequences of that deletion.

There is no "undo" for that action.


Gord Dibben MS Excel MVP

On Fri, 16 Jan 2009 17:40:03 -0800, Daisy
wrote:

Can you reinstate deleted sheets in excel, if so how please. thanks


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 print sheets in Excel without blank sheets after page Peggy New Users to Excel 2 January 12th 08 11:10 AM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? Dmitry Excel Worksheet Functions 6 March 29th 06 12:43 PM
In 3 active sheets in wkbk, determine& display the # of sheets that have data wrpalmer Excel Discussion (Misc queries) 1 November 4th 05 02:01 PM
populating sheets based on data from parent sheets seve Excel Discussion (Misc queries) 2 January 15th 05 09:22 PM


All times are GMT +1. The time now is 12:15 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"