removing personal.xlsb file

  • Thread starter Thread starter Lotto
  • Start date Start date
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?
 
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
 
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?
Click to expand...

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
 
Back
Top