If I delete it from the xlstart directory it will create a new one if I record a macro but if I close and reopen excel it is not available and unhide is greyed out although the personal.xls exists in the xlstart folder.
If I put other files in the xlstart folder they are found and opened when excel is run?!
Anyone experienced this in the past or have any ideas.
I can use alt under general options to create a new one close to the root directory(it then works) but not in the default location?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hey Steve,
What happens if you use file/open to open the personal.xls file from xlstart?
Matt
Matt,
I can open it that way. It opens with the personal.xls unhidden with one sheet(which is what my personal.xls has).
If I double-click on it from explorer it behaves differently....it opens hidden with no sheet showing.
By either method above: After closing and re-opening Excel the personal.xls is not recognized. Unhide is greyed out so its not listed as a hidden sheet and its not listed in the vbe.
Seems like Excel is looking in the wrong place for it or doesn't recognize it? It's odd though because it is the personal.xls that was saved to the default location when I recorded a macro...?
When this happened I also lost the icons from my one custom toolbar that ran the macros in my personal.xls. Don't understand why but maybe it gives someone a clue.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hmm.. just another idea (doubtful if you didnt do anything to change it), what does the registry say? (start/run, regedit)
HKCU\Software\Microsoft\Office\x.x\Common\General
under xlstart? it should just say XLSTART
What happens if/when you move your personal.xls, record a macro (so it creates a new one), save that, and close excel? does the new one open up with excel?
just brainstorming some suggestions
Keep thinking Matt....registry checks out as you detailed. I had already tried moving the personal.xls....then recording a macro to create a new one. It creates it and it is available as long as you don't close excel. After closing and re-open excel its not available..its a total mystery to me.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hi Lucas,
See if this helps. In excel go to your Help bar and click on Detect and Repair. I know Office 2000 and up has that feature but before that I dont know.
SHAZAM!
Would like to mention again that I also lost all custom buttons when this happened and that I have run detect and repair and scanned with norton.
Hi Shazam. Thanks for the suggestion. We posted at the same time. Office 2003 SP1
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hey Steve,Originally Posted by lucas
I wouldn't think this would have anything to do with it, but since nothing else has worked... Have you tried deleting your *.xlb files to kill all instances of your custom toolbars? You can always create them again later, but if the issue is in the toolbar, maybe it is affecting the personal.xls?
Doubtful, but worth a shot, maybe.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
even the new one isnt available? interesting! just to confirm:
(im gonna call them personal1.xls and personal2.xls despite them both being called personal.xls)
-personal1.xls is in xlstart, not opening with excel
-you move personal1.xls to another folder
-create personal2.xls by recording macro, it saves to xlstart
-you close excel, reopen, and personal2.xls doesnt show up?
and the alternate startup file location is blank in the options?
are you having the same problem with normal.dot in word?
this is doubtful, but just to check.. after closing excel, go to the task manager, are there any other instances of excel.exe running? what about a system restart, im sure you've tried that?
the fact that your toolbar got changed does give a clue that something got corrupted.. have you tried detect and repair (or the commandline switches to un/re-register it)?
to do the re-registering of it, go to start/run and put in:
excel.exe /regserver
that re-checks all the registry entries
You might also want to search your computer for "xlstart", see if another exists somewhere
The above is correct. Doesn't make sense does it?
correct
No problem with normal.dot
No extra sessions running...check process also.
both tasks completed with no joy.
Ken, I zipped both xlb files then deleted(there were 2 excel.xlb & excel11.xlb) ran excel and it created a new one...still no joy.Hey Steve,
I wouldn't think this would have anything to do with it, but since nothing else has worked... Have you tried deleting your *.xlb files to kill all instances of your custom toolbars? You can always create them again later, but if the issue is in the toolbar, maybe it is affecting the personal.xls?
I would like to add that this is not really affecting my use of excel, just a total mystery.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
what version?
if >= 2002 go to Help / About, then disabled items, is it in there?
is it in the right startup folder? (there's more than 1) Try this to find correct path [VBA]MsgBox Application.StartupPath[/VBA]
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
That was it Matt. I had never seen this option before but we have a personal.xls and my buttons have returned. Thanks for staying with me on this as I had run out of ideas. Thanks to Ken, Shazam and others for their input.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Thanks John, that returns the correct path....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Nice work, Matt!
I'd never actually noticed that little message box before either. Hardly ever look in the about screen at all, actually.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Yeah, alright! The guy who stubbornly stays with excel 2000 got it!
I'd like to thank the monkeys at google for their tireless efforts, if they didn't transcribe every webpage into their DB we'd all be nowhere
Posting Permissions
Reply With Quote
