Author Topic: Excel file opens - but no data!  (Read 1496 times)

Offline RustyNuts

  • RootsChat Extra
  • **
  • Posts: 73
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Excel file opens - but no data!
« on: Monday 15 May 17 02:19 BST (UK) »
Hi

I have a simple Excel spreadsheet that I use to record receipts and expenses. I enter data most days and save after every update.  Yesterday, I used the spreadsheet as usual, saved and closed Excel.  Later, I had more receipts to enter, opened file ok but there was no data.  Everything had gone. All other excel files are fine. Following advice, I checked recycle bin, ran CCleaner, full Malwarebytes scan, downloaded Recuva, did a system restore, checked for hidden data and searched in vain for duplicate/previous copies of the workbook.

I guess this data is gone for good but can anyone advise what could have caused this?  I have limited technical skills so never play around with settings and no-one else has access to my laptop.

Tks

Offline majm

  • RootsChat Marquessate
  • *******
  • Posts: 25,385
  • NSW 1806 Bowman Flag Ecce signum.
    • View Profile
Re: Excel file opens - but no data!
« Reply #1 on: Monday 15 May 17 02:29 BST (UK) »
It may be worth checking that you had not inadvertently opened a new worksheet within your excel file.   Perhaps your work is still there on sheet 1

JM
The information in my posts is provided for academic and non-commercial research purposes. 
Random Acts of Kindness Given Freely are never Worthless for they are Priceless.
Qui scit et non docet.    Qui docet et non vivit.    Qui nescit et non interrogat.   
All Census Look Ups Are Crown Copyright from www.nationalarchives.gov.uk
I do not have a face book or a twitter account.

Offline Rosinish

  • RootsChat Marquessate
  • *******
  • Posts: 14,239
  • PASSED & PAST
    • View Profile
Re: Excel file opens - but no data!
« Reply #2 on: Monday 15 May 17 03:08 BST (UK) »
It may be worth using the search option & typing in something you know you typed (exactly how you typed it) & it should come up if you have inadvertently saved it elsewhere?

Annie

Added,
Depending on which windows system you use the search facility works differently e.g. XP & Vista searches work differently.

South Uist, Inverness-shire, Scotland:- Bowie, Campbell, Cumming, Currie

Ireland:- Cullen, Flannigan (Derry), Donahoe/Donaghue (variants) (Cork), McCrate (Tipperary), Mellon, Tol(l)and (Donegal & Tyrone)

Newcastle-on-Tyne/Durham (Northumberland):- Harrison, Jude, Kemp, Lunn, Mellon, Robson, Stirling

Kettering, Northampton:- MacKinnon

Canada:- Callaghan, Cumming, MacPhee

"OLD GENEALOGISTS NEVER DIE - THEY JUST LOSE THEIR CENSUS"

Offline RustyNuts

  • RootsChat Extra
  • **
  • Posts: 73
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Excel file opens - but no data!
« Reply #3 on: Monday 15 May 17 03:23 BST (UK) »
Tks Rosinish and majm

I use Windows 7 on laptop.  Have tried searching on file name but only the one copy comes up.  I recall being able to search on a word in the file when I had XP but not sure how to do this in W7.

Have just checked the worksheets in the excel file but nothing there.

One of life's mysteries!


Offline Rosinish

  • RootsChat Marquessate
  • *******
  • Posts: 14,239
  • PASSED & PAST
    • View Profile
Re: Excel file opens - but no data!
« Reply #4 on: Monday 15 May 17 03:26 BST (UK) »
Try your search (not with the file name) but with something you typed on the excel sheet, exactly as you typed it.

Annie
South Uist, Inverness-shire, Scotland:- Bowie, Campbell, Cumming, Currie

Ireland:- Cullen, Flannigan (Derry), Donahoe/Donaghue (variants) (Cork), McCrate (Tipperary), Mellon, Tol(l)and (Donegal & Tyrone)

Newcastle-on-Tyne/Durham (Northumberland):- Harrison, Jude, Kemp, Lunn, Mellon, Robson, Stirling

Kettering, Northampton:- MacKinnon

Canada:- Callaghan, Cumming, MacPhee

"OLD GENEALOGISTS NEVER DIE - THEY JUST LOSE THEIR CENSUS"

Offline hallmark

  • ~
  • RootsChat Marquessate
  • ****
  • Posts: 17,525
    • View Profile
Re: Excel file opens - but no data!
« Reply #5 on: Monday 15 May 17 05:31 BST (UK) »
Are you looking at Cell A1?

Did you inadvertently change Font colour to White?
Give a man a record and you feed him for a day.
Teach a man to research, and you feed him for a lifetime.

Offline ReadyDale

  • RootsChat Veteran
  • *****
  • Posts: 697
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Excel file opens - but no data!
« Reply #6 on: Monday 15 May 17 07:25 BST (UK) »
All above suggestions plus .... have you hidden the worksheet?

Offline RustyNuts

  • RootsChat Extra
  • **
  • Posts: 73
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Excel file opens - but no data!
« Reply #7 on: Monday 15 May 17 13:01 BST (UK) »
Tks Annie, ReadyDale and hallmark

Very grateful for your further suggestions but have drawn a complete blank.  I definitely have not changed any settings.  I am familiar with hide/unhide now as a result of this problem but have never used it previously. I have tried searching on a range of suppliers that I know I appear often in the workbook. 

I will get the laptop checked out professionally although I fear the data is gone for good.

Tks again to everyone.

Offline ReadyDale

  • RootsChat Veteran
  • *****
  • Posts: 697
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Excel file opens - but no data!
« Reply #8 on: Monday 15 May 17 13:58 BST (UK) »
Although not impossible, I am guessing you haven't actually deleted ALL the data accidentally without noticing, just hidden it in some way from yourself.
Is the tab/worksheet that contained all the data still there?
     If not, double check it is not just hidden
If the tab/worksheet is there, select all the cells (by clicking in the corner where the row and column references meet (top left by A and 1), unhide all columns and rows, then again do a find on text that is KNOWN to exist (as mentioned, you may have made the text white, so keep an eye on the formula bar which will the display text too).

If all else fails, restore from backup (you do back up don't you?)