lost personal file

Eric Kelcher

Board Regular
Joined
May 11, 2006
Messages
129
Well not actually lost (misplaced?) but the personal file macros are no longer available without opening personal.xls. Personal is not hidden it just appears to not be there, I can go do a search and find the "hidden version" in hidden/system folder->Application Data\Microsoft\Excel\XLSTART.
How do I recreate it so it is always there? I can get all the macros I need from this "searched" version but there is a very good possibilty I deleted the normal version as I had issues and I had excel crash and it was one of the recovered files and I clicked that I had saved all the files I needed. Now it no longer is accesible directly via macro or there when I try to unhide files under window task. When I open this version it acts just like normal personal I can hide it and macros are still useable, etc.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Eric

If you go Tools>Macro>Record New Macro select to create it in your Personal.xls. Excel should then recreate the file in the correct location and you can copy and paste your macros in to the new one.

Hope this helps!

Richard
 

Eric Kelcher

Board Regular
Joined
May 11, 2006
Messages
129
That is what I was hoping too but it didn't work.

I get error message.

Personal Macro Workbook in the startup folder must stay open for recording.

Then

Unable to record
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Eric

Try renaming your existing Personal.xls to something else (or move it out of the XLSTART folder) and then repeating the steps I gave above. Post back if it's still a no go.

Richard
 

Eric Kelcher

Board Regular
Joined
May 11, 2006
Messages
129

ADVERTISEMENT

Tried changing the existing personal file name then recorded new macro same issue. It made a new file called Personal stored in same location as old one, but personal macros are still not available when personal is not open. ???
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Eric

Sorry, I think I misunderstood your problem - the Personal.xls is always normally open, it's just that it is hidden (and can be unhidden by Windows>Unhide). Because it is located in XLSTART and is normally saved down as hidden, it will open up under normal Excel operation every time you start Excel, but will remain hidden. Maybe this is why you thought it wasn't open?

Richard
 

Eric Kelcher

Board Regular
Joined
May 11, 2006
Messages
129

ADVERTISEMENT

That is my problem it is not opening when I start Excel. I have to manually go and open it to use the Personal macros. IE it is not listed as a hidden file under Windows actually it is showing that there are no hidden files.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
And it's still in your XLSTART? Not sure why it isn't opening up then (unless some kind of setting on your computer has been messed up - beyond my ability resolve though). However, you may be able to get Excel to open the file by creating a new folder on your computer (say on "C:\ExcelAlternateStartUp\") by, in Excel, going Tools>Options>General tab and then navigating to the box towards the bottom labelled "At startup, open all files in:" and type the alternate folder location in here. Make sure you copy over your Personal.xls into this folder location afterwards, so it's there to open.

I'd be interested to hear if this does indeed work.

Richard
 

Eric Kelcher

Board Regular
Joined
May 11, 2006
Messages
129
Yeah it is in XLSTART that is what is killing me.

Tried making the alt start program still does not work.

Yeah this is real confusing. :oops:
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Eric

Does any other workbooks you place in either XLSTART or the alternative start location open up, or do these stay closed when Excel boots up?

Richard
 

Forum statistics

Threads
1,141,626
Messages
5,707,489
Members
421,510
Latest member
haroonstr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top