1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

Discussion in 'Business Applications' started by nrheffley, Nov 17, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. nrheffley

    nrheffley Thread Starter

    Joined:
    Nov 17, 2012
    Messages:
    3
    I am running Microsoft Office Professional Plus 2010 on Windows 7.

    When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

    BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:

    1. In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
    2. In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
    3. In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
    4. In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
    5. I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
    6. I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
    7. I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

    Thank you in advance for any help or suggestions.

    Nick
     
  2. Sponsor

  3. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Why do you want it in xlsa?
     
  4. nrheffley

    nrheffley Thread Starter

    Joined:
    Nov 17, 2012
    Messages:
    3
    Thank you for your reply Garf13LD. I don't want it in xlsa that was just a suggestion that helped someone else with a similar issue that I tried. I just want my macros to be available when I open an existing excel file.
     
  5. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Try putting it in excel startup or office startup.
     
  6. nrheffley

    nrheffley Thread Starter

    Joined:
    Nov 17, 2012
    Messages:
    3
    Thank you Garf13LD. I copied my personal.xlsb from C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and pasted it into C:\Program Files (x86)\Microsoft Office\Office14\XLSTART and I now have my macros when I open an existing excel file.

    Thank you again

    Nick
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - PERSONAL XLSB does
  1. PincivMa
    Replies:
    4
    Views:
    381
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1077118

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice