?
Solved

Excel Macros Not Available

Posted on 2012-09-22
8
Medium Priority
?
358 Views
Last Modified: 2012-09-25
I recently switched to a new computer(64 bit Windows 7) with Excel 2010. I had several macros available in Excel 2007 on my old computer. When I go to macros now there are no macros available. Is it possible to resurrect these macros? Unfortunately my old computer is trashed but I would have an old backup. Thanks for the help
0
Comment
Question by:StampIT
  • 4
  • 4
8 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 38424985
Hi, StampIT.

I assume that your macros were in a file that was loaded when Excel started. Usually the file is called Personal.xlsm (or Personal.xlsb or Personal.xls). The default locations in Excel 2007 are listed here (the most likely being C:\Documents and Settings\User_name\Application Data\Microsoft\Excel\XLSTART).

I'd start by checking your backup for XLSTART folders, then try for any Personal.xlsm/xlsb/xls files. In the extremely unlikely event that neither of these work, it's probably a matter of checking the backup for folders with, say, a single Excel file in them. (Let me know if this is the case and we'll sort out something a bit more efficient.)

Regards,
Brian.
0
 

Author Comment

by:StampIT
ID: 38425074
Unfortunately I did not back up everything in my old C:. On the backup I have I have looked for the Personal.xlsm thinking it might be in My Documents. Apparently it would have been in C:\Documents and Settings.....Without that I presume I am out of luck ? I will try to get into my old hard drive somehow.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38425090
StampIT,

Without that I presume I am out of luck ?
Except for the unlikely possibility that you had specified your Start-Up folder elsewhere, then I'm afraid that's correct.

Can you produce a listing of the backup's contents (or mount it with a drive letter)? If so, we can produce a list of all spreadsheets, to be sure.

Regards,
Brian.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:StampIT
ID: 38433145
I was able to find Personal.XLSB that does contain the macros. Found it in C:\Users\mjd\App Data\Roaming\Microsoft\Excel\XLSTART. Was able to use my old hard drive. Where on my new Windows 7 64 bit computer should I put this file so Excel 2010 will see it ?
0
 
LVL 26

Accepted Solution

by:
redmondb earned 2000 total points
ID: 38433488
StampIT,

You have three choices...
(1) C:\Documents and Settings\User_name\Application Data\Microsoft\Excel\XLSTART
(2) The alternate startup file location - specified in the "General" section of the "Advanced" tab in Excel's "Options".
(3) C:\Program Files\Microsoft Office\Office14\XLSTART. This address assumes that Excel is installed in c:\Program Files\Microsoft Office\Office14.

I don't recommend (3) as making changes to your Personal.xlsb would require Administrator access.

Regards,
Brian.
0
 

Author Closing Comment

by:StampIT
ID: 38433666
I put the PERSONAL.XLSB in the C:\Users\UserName\AppData\Roaming\Microsoft\Excel\XLSTART. It works. Excel can find it. However I cannot edit the macros. It says I must unhide the workbook. How do I do that ?

Thanks for the help, Brian.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38433812
Thanks, StampIT.

If you just want to update its macros then it's unnecessary to unhide your Personal.xlsb. On the "Developer" ribbon, click on the first button ("Visual Basic") to display the IDE. You should then be able to find your Personal.xlsb in the Project Explorer pane.

However, you may need to unhide it to update its sheets. On the "View" ribbon, click on the "Unhide" button.

Regards,
Brian.
0
 

Author Comment

by:StampIT
ID: 38433899
Thanks Brian.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question