Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 continues to put macros in old user profile XLSTART


16 Mar 2014   #1

Windows 7 Pro 64 bit
 
 
Excel 2010 continues to put macros in old user profile XLSTART

I am rebuilding my Win 7 in a new user profile and am now trying to get my macros into the new user profile XLSTART. Every time I create a test macro to see were Excel will place it, it ends up in the old user profile XLSTART. (My old user profile was corrupted by disk problems that have been fixed by CHKDSK. It became unusable and I was unable to log back into it. I am keeping it around because it may have some useful data files.)

I have tried using the File Options Trust Center Trust Center Settings where a list of user locations specifies trusted locations for Excel. I would have thought that specifying the XLSTART here would fix the problem. Alas, a new personal.xls gets created in the old user profile location.

Would anyone know how I could get Excel to begin using the XLSTART in my new user profile? Any help here will be greatly appreciated.


My System SpecsSystem Spec
.

16 Mar 2014   #2

Microsoft Community Contributor Award Recipient

Windows 7 SP1, Home Premium, 64-bit
 
 

I can use Excel pretty well and I do use a couple of macros---but I'm pretty shaky on profiles, trusted locations, etc.

Here is what I show. I don't have any problems so far.


Attached Thumbnails
Excel 2010 continues to put macros in old user profile XLSTART-untitled-1.jpg  
My System SpecsSystem Spec
16 Mar 2014   #3

Windows 7 Pro 64 bit
 
 

Quote   Quote: Originally Posted by ignatzatsonic View Post
I can use Excel pretty well and I do use a couple of macros---but I'm pretty shaky on profiles, trusted locations, etc.

Here is what I show. I don't have any problems so far.
Thank you for responding, ignatzatsonic.

Here is what I get. The clip below shows where Excel 2010 finds the Personal.xlsb file, in the old profile (wgra).

Excel 2010 continues to put macros in old user profile XLSTART-personal-xls-location.png

Below are the Trusted Locations with the new profile (wgr) path to XLSTART that I set up and is ignored by Excel.

Excel 2010 continues to put macros in old user profile XLSTART-trust-center-files.png



Interestingly, the images I made with the Snipping tool were automatically saved in the old profile - wgra. This shows I still have a lot of work fixing the default file locations of my new profile, wgr.

It's good that you don't have my problems. Your profile is quite sound and usable.


My System SpecsSystem Spec
.


16 Mar 2014   #4

Microsoft Community Contributor Award Recipient

Windows 7 SP1, Home Premium, 64-bit
 
 

Can't help you any further.

For what it's worth, I have no .xlsb files anywhere in my PC. I'd never even heard of them, but just did a disk search and found none. Supposedly a "binary" file. Means nothing to me.

I use only 1 profile.
My System SpecsSystem Spec
16 Mar 2014   #5

Windows 7 Home Premium 64 bit sp1
 
 

Have you tried setting up a Documents directory under Libraries. From what I can see from your Snips your Excel files are being saved directly to your OS C drive, which is not where they should be.

When you have set up the documents directory, open it & create a new Folder & call it something like Excel Macros or whatever suits you. Now you can copy those macros from your C drive to the new Folder under Documents. Click on the macros in this folder & see if they open properly & if so delete the old ones on your C drive.

In future if you want to save any new macros, select File & where it says "Save as" select 'Browse" & locate your new Folder that you created under Documents & save it there.

In addition you can set up a another Folder as described above & name it Excel Spreadsheets & save your spreadsheets there as well.

Libraries are very useful & I use them all the time.

Also you can set up a short cut to your desktop that will take straight Macros Folder if you wish, so you then select which one you want from there. Just right click on the Folder & select Send To Desktop (create short cut).
My System SpecsSystem Spec
17 Mar 2014   #6

Windows 7 Pro 64 bit
 
 

Thanks for your efforts, ignatzatsonic. I feel very much out of my depth here, too, but will give it a few more tries.

Thank you very much for responding, Ranger. I have tried some of your suggestions with no success. My new user profile seems to have many links back to the old profile and I'm hoping that someone knows of locations where these links are made so that I can change the file locations to the new profile.

Some of the things I've tried were to rename XLSTART in the old profile to XLSTARTa and Excel 2010 doesn't find it. I have an XLSTART in the new user ROAMING directory but it completely ignores it. For example, when I try to customize the ribbon by adding a macro, the customization screen returns a blank list of where the macros are supposed to be instead of the list of macros that are in the PERSONAL workbook. As it stands, the only way I can get this Excel to use macros is by having an XLSTART in the old profile. This jumble must have happened happened when I did a restore of my files from my online backup service.

It seems like this would be an easy problem to fix but it's quite exasperating. My day job doesn't give me the luxury of time to explore the intricacies of Win 7 and Office 2010. Unless I find a relatively straightforward fix to this I will go about building a brand new profile and move my many customization's over one by one.
My System SpecsSystem Spec
17 Mar 2014   #7

Windows 7 Pro 64 bit
 
 

Ranger,

I did reread your post and the point you made about libraries was very helpful.

After reading more about libraries and the tutorials here, I found that they were using folders from the old profile. After fixing that, my default saves of the programs I tried went to the new profile. My macros, though, continue to come and go from the old profile.
My System SpecsSystem Spec
17 Mar 2014   #8

Windows 7 Home Premium 64 bit sp1
 
 

Thanks wgrxx for the update & I am glad that was of some help.

Regarding your macros. You could try opening them & then save them as I suggested in post 5, but give each one a new name. This should give you a new copy, which hopefully will be saved in the new folder & leave the old one on your C drive as it was. Test the new ones to see if they work as they should & then delete the old ones.

I was just rereading your post 6 & I see that you renamed your XLSTART macro & Excel could not find it, which is perfectly normal. What you need to do is to open them & save them giving each one a new name as I mentioned above, then Excel will be able to find them.
My System SpecsSystem Spec
Reply

 Excel 2010 continues to put macros in old user profile XLSTART




Thread Tools



Similar help and support threads for2: Excel 2010 continues to put macros in old user profile XLSTART
Thread Forum
Solved Excel 2010 Macros Will Not Run On A New Machine Microsoft Office
enabling macros in Excel Microsoft Office
Excel 2003 Macros do not run correctly on a Windows 7 system. Microsoft Office
Excel Macros Disabled Under W7 Microsoft Office
Running old Excel macros in Windows 7 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 11:46 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33