Personal Workbook Problems

[spg2112]

Hey all,

Excel crashed on me today at work. I honestly didn't take the time to read the entire error message, but when I re-started Excel, my personal workbook was gone, and my command button for the macros was gone! I went to the Excel start folder and the file is still there, however I have to open it each time I start Excel now, and when I tried re-building my toolbar, it still doesn't work. It opens the Macro Edit screen.

What the hell happened to my personal workbook? I think I'm Excel XP. If it is corrupt how can I restore it?

Steve

 

[shelnrik]

My file did that once. I had to resave it in the XLStart file.

Mine is located under
C: Documents and settings/Application Data/Microsoft/excel/XLStart

Hope that solves your problem.

Shel <><

 

[spg2112]

Thanks Shel but that didn't work. Anybody else have any ideas?

Steve

 

[Zack Barresse]

if your os is xp, have you tried system restore?

just a thought

a good thread was:
http://www.mrexcel.com/board2/viewtopic.php?t=73014&highlight=recovering+deleted+information

 

[TryingToLearn]

You may also want to view this:


http://www.mrexcel.com/board2/viewtopic.php?t=73352&highlight=xlb



If it's not too late, check your recycle bin as well.

GL

 

[Cbrine]

Just as a note. I just ran into a problem with my personal macro workbook. The button's were still on my toolbar, but they kept telling me they couldn't find the personal workbook. The cause was some invalid syntax in one of my sub's, but it stopped ALL my sub's from working.