Cant see data in excel file.

[grvs]

Hi
I saved an excel (.xls) file few weeks back. its size is around 2.2 MB. But when I opened it today, i see a blank file. I was using excel 2007, so I asked a friend who has excel 2003 to open it. He also sees a blank file. I have checked that it doesnt contain any hidden sheets or macros.

One strange thing is when press ctrl + arrows then i move the the end of the file. However when I press Ctrl + End then I move a cell F15304 (I think upto this cell I had data in this file).

Can anyone please help?
I have attached the file after zipping it.

Thanks
Gaurav

[tigeravatar]

Gaurav,

I took a look at the file. Confirmed its only 1 sheet (not even any VeryHidden sheets) with a UsedRange of A1:F15304, no macros, no conditional formatting. Set columns A:F cell format to general, font color to automatic (black), fill color to none, still nothing in that range. Looking for SpecialCells(xlCellTypeBlanks) resulted in the same range, A1:F15304. Found there was a named range hard coded to A1:F15304, so that was interesting, but there's nothing in those cells, and nothing anywhere else on the sheet. Whatever was in that file appears to just be gone, sorry

~tigeravatar

[tigeravatar]

Cross-post http://www.mrexcel.com/forum/showthread.php?t=575908

[grvs]

Thanks a lot tiger.
I posted at two forums to find out faster answers and you gave me fast answer infact. Dint know same people are active at both forums :D

Edit - However when think of it again, my first question arise, why filesize is still 2.2 MB when there is no data.