removing personal.xlsb file

L

Lotto

I am having some serious issues with files not acting on my machine as
they do on others. I am a higher level user, and thought that maybe
it was due to my personal.xlsb workbook interfering with the others
that I'm trying to open. I removed the file from my C drive, copying
to a flash drive, which i unplugged. I then deleted the copy from the
recycle bin. Nothing in xlstart folder. When I open a new blank
workbook, these files still show in the background. Where are they
hidden?
 
Joined
Jul 19, 2011
Messages
20
Reaction score
0
It could be in another (initial or alternative startup folder). Or you could try using Windows Find to locate it. Or, when it is there, go into the VBE and put a macro into it:
Sub WhereAmI()
Msgbox ThisWorkbook.FullName
End Sub

Bernie
 
A

Andrew

I am having some serious issues with files not acting on my machine as
they do on others.  I am a higher level user, and thought that maybe
it was due to my personal.xlsb workbook interfering with the others
that I'm trying to open.  I removed the file from my C drive, copying
to a flash drive, which i unplugged.  I then deleted the copy from the
recycle bin.  Nothing in xlstart folder.  When I open a new blank
workbook, these files still show in the background.  Where are they
hidden?

This may be over my head, but this is what I think....Go to the
registry "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel"
This is the path if you have windows 7 and excel 2010. It is slightly
different for excel 2007. I think the second to the last folder name
is 12.0.
Rename the folder "Excel" to "Excel_old". Then restart Excel. Excel
will not find it's registry entry because you renamed it. Excel will
then
create a new entry. You will lose all of your history and settings,
but that might be what you are looking for. If this doesn't work,
delete the newly created
Excel folder and rename the previous one back to "Excel" and you will
be back to square 1.

Good luck.

Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top