Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible to retrieve a program that has been saved over? | Excel Discussion (Misc queries) | |||
How to retrieve entire row (actually 26 columns) of data ? | Excel Worksheet Functions | |||
retrieve a saved over file | Excel Discussion (Misc queries) | |||
How do I retrieve a saved over file? | Excel Discussion (Misc queries) | |||
How to retrieve last saved version. | Excel Discussion (Misc queries) |