Excel 2010 opens but no worksheet is showing

[DougP]

background I had a Access datbase in the C:\Users\z533560\AppData\Roaming\Microsoft\Excel\XLSTART folder somehow which prompted No data source found and was very annoying. I dleted that file but now when I open Excle I have no worksheet until I click "NEW" on the quick access bar. I found elsewhere to add a "blank.xlsx" in that folder which opens but when I save it, it does not prompt and just saves the contennts into the blank whereby I have to do a saves as.
If I remove the Blank then I have to click New to get a worksheet which is then called book1, and I can save it and it prompts like normal.

How do I get back to the default settings? Opening Excel and having abook1 whihc would prompt to save like normal.

DougP

 

[kjv1611]

What version of Excel? (I'm assuming 2007 or 2010)

Sounds like a repair of Excel would just put everything to default settings.

Why in the world you had a database in that folder makes no sense to me either. Really, it should be blank, or just have a default workbook there if you have default preferences. Also, if you use Macros, then you should have a PERSONAL.XLSB file in that folder. And that file could then contain your default file settings (say you want 4 sheets instead of 3 by default - or whatever other preferences).

But if you just want "out of the box" settings, then running office repair should fix it.

Info about and how to run Office Diagnostics and Repair in Office 2007

This will work regardless of version of Office to get to diagnostics and repair

One more reference



"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[DougP]

2010, I have a PERSONAL.XLSB in that folder and I deleted eveything but it.
Now when I open Excel Istil get a blank sheet and have to click New. so there are not sheets in my PERSONAL.XLSB.
If I click new and then save it propmpts with a book1... and wants to save it as somethign else, how can I add a sheet to it?
I am at a "very large" corporation so I can't re-install it without a help desk call. I don't have any disks, it was pushed down using Marimba.

DougP

 

[zelgar]

Is it possible that the sheet was moved off-screen? Try using the Arrange All command under the View tab and see if it comes back. If everything is greyed out, then there aren't any open sheets.

 

[DougP]

Uh now its working????? Just fine
I messed wioth something the othe rday but have not gotten back in there til I see your post just now

so I assume it fioxed looks like it thank's though all
...
Happy holidays

DougP

 

[kjv1611]

Well, glad it's working now.

Maybe it was a Christmas Miracle!

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

... or maybe a Mayan mystery!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kray4660]

Do Office products run on the Mayan calender? If so, it could be a rough day tomorrow. I am glad I will be on vacation.

 

[SkipVought]

So you REALLY believe that a vacation will spare you! ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kray4660]

No, but at least I will be with family!!!