Serious Trouble with Excel file opening.?

Question

I have Office 2007. I amended my excel file today, and saved it. Now i m trying to open the file, it opens and shows worksheet but there are no gridlines, I can not c my data, the whole worksheet are light blue color, toolbars are visible on the top but i can not select them. Status is showing Ready. It is around 40 Kb files which i feel that it contains data but where i dont know. Bc if it is empty then it must be 8.5 KB which is normal size of excel. Pz help me, Thanks in advance

Update:

I have Excel 2007, i went to help and wrote edit template but i did not find the option for book and sheet, pz help me. it is my impartant file

chezzrob · Accepted Answer

use explorer and try and find the file. Make sure the view is list and you can see the file extension

Is the file a excel 2003 or 2007 file?
if its a 2003 rename the extension to .xls.  If its a 2007 it be something different, but if its a 2003 file so you need to open it as a 2003 which is xls.


if the file was an original 2007 file then you are in deep s**t.

Sounds like you have changed the default templates and saved the template in a corrupt state.
you need to find the template and delete it, Excel will automatically make a new one on re opening.

open excel and hit Fn1 key, type in edit template.  There should be two, one for the book, and one for the sheet. The help should tell you their names and where to find them. Use explorerer and find both and delete them.

If your file in question was not saved as a template extension then it should open to the new default template and should make sense/  if your file in question was saved as a template (determined by the file extension) then it may be lost.  you could rename the extension from template to file  before you delete the default templates , may be able to save some data.

good luck.

Trending News

Serious Trouble with Excel file opening.?

1 Answer