Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Missing several columns of saved data. Retrieve possible?

When I opened worksheet, about 5-10 columns of stored data were missing. They
should have been to the left of the data I was looking at. Is retrieval
possible, and if so, how? Thanks.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Missing several columns of saved data. Retrieve possible?

If they are truly missing and you do not have a backup/older copy of the
file, then the data is lost.

However, before tying the rope to the cieling beam, try making certain that
it really is gone:
Open the book and save it with a new name.
Select a row by clicking on any row number and use Format | Columns and make
sure that none are hidden.
After making sure that no columns are hidden, select all cells by clicking
the blank gray square just above the [1] row number and left of the [A]
column indicator then use Edit | Clear and choose [Formats] - this would
cause any entries set in very small font size or that had their font color
set to the background color to make them appear invisible.

Good luck.

"semloh2" wrote:

When I opened worksheet, about 5-10 columns of stored data were missing. They
should have been to the left of the data I was looking at. Is retrieval
possible, and if so, how? Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default Missing several columns of saved data. Retrieve possible?

One other option I've had some success with is to try opening the file
using Sun's Calculator (it's the star office version of Excel- this
is a free program just google it).

I had a corrupted excel file not too long ago. Excel would open it and
crash. I was able to open it in Star Office and save it as an excel
document with very minimal data loss.

On Aug 2, 9:12*am, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
If they are truly missing and you do not have a backup/older copy of the
file, then the data is lost.

However, before tying the rope to the cieling beam, try making certain that
it really is gone:
Open the book and save it with a new name.
Select a row by clicking on any row number and use Format | Columns and make
sure that none are hidden.
After making sure that no columns are hidden, select all cells by clicking
the blank gray square just above the [1] row number and left of the [A]
column indicator then use Edit | Clear and choose [Formats] - this would
cause any entries set in very small font size or that had their font color
set to the background color *to make them appear invisible.

Good luck.

"semloh2" wrote:
When I opened worksheet, about 5-10 columns of stored data were missing.. They
should have been to the left of the data I was looking at. *Is retrieval
possible, and if so, how? *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
Is it possible to retrieve a program that has been saved over? Ccat711 Excel Discussion (Misc queries) 1 July 20th 08 07:46 PM
How to retrieve entire row (actually 26 columns) of data ? Father Jack Excel Worksheet Functions 3 June 7th 07 04:35 AM
retrieve a saved over file pcorci Excel Discussion (Misc queries) 1 January 3rd 07 07:40 PM
How do I retrieve a saved over file? cat Excel Discussion (Misc queries) 1 September 30th 05 07:39 PM
How to retrieve last saved version. Deichelb Excel Discussion (Misc queries) 1 January 27th 05 07:17 PM


All times are GMT +1. The time now is 07:23 AM.

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"