Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dustin D. Cook
 
Posts: n/a
Default Renaming File Removes Worksheets

A user in my organization has renamed one of her Excel files. Subsequently,
the first worksheet in her file appears to be renamed to the new file name
and none of her other worksheets are listed at the bottom of the application
window. Pressing Ctrl+PgUp and Ctrl+PgDn do not shift between worksheets as
Excel thinks there is only one.

Are there any possible ways of recovering these lost worksheets without
resorting to an Excel recovery tool such as R-Excel Recovery or XLS
Regenerator?
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

sounds as though she has saved it as a CSV or TXT file, meaning that you may
be lucky enough to find the original XLS file in its original location.
Saving it in one of these formats requires the user to acknowledge that Excel
will only save the active sheet, so it wasn't a complete *accident*.
Meanwhile, Excel doesn't overwrite the XLS file with new file, either, so
take a look for it



"Dustin D. Cook" wrote:

A user in my organization has renamed one of her Excel files. Subsequently,
the first worksheet in her file appears to be renamed to the new file name
and none of her other worksheets are listed at the bottom of the application
window. Pressing Ctrl+PgUp and Ctrl+PgDn do not shift between worksheets as
Excel thinks there is only one.

Are there any possible ways of recovering these lost worksheets without
resorting to an Excel recovery tool such as R-Excel Recovery or XLS
Regenerator?

  #3   Report Post  
Dustin D. Cook
 
Posts: n/a
Default

"Dustin D. Cook" wrote:

A user in my organization has renamed one of her Excel files. Subsequently,
the first worksheet in her file appears to be renamed to the new file name
and none of her other worksheets are listed at the bottom of the application
window. Pressing Ctrl+PgUp and Ctrl+PgDn do not shift between worksheets as
Excel thinks there is only one.


"Duke Carey" wrote:

sounds as though she has saved it as a CSV or TXT file, meaning that you may
be lucky enough to find the original XLS file in its original location.


Your response led me to the solution. She had never saved the file as an
Excel workbook. She was working on data exported from another source into a
CSV file and was unaware CSV did not support multiple worksheets. When she
finally closed Excel and re-opened the file the worksheets were not there
because they had never been saved - not because the file was renamed.

Thank you for your prompt response. Have a nice day.
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
Is there a limit to the number of worksheets in an excel file? NIRVL Excel Discussion (Misc queries) 1 March 16th 05 03:02 PM
One file splitted into worksheets Heine Excel Worksheet Functions 0 March 9th 05 11:23 AM
multiple worksheets in html - one file Mikael Excel Discussion (Misc queries) 0 March 3rd 05 07:55 PM
Copying and renaming a file Craig Excel Discussion (Misc queries) 1 February 24th 05 10:47 PM
How to protect and unprotect 30 worksheets in a file every month . Protect & Unprotect Several Worksheets Excel Worksheet Functions 4 January 10th 05 01:29 PM


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