Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    personal.xls revisited (Excel 2003)

    I have my personal.xls file located at:
    Cocuments and SettingsAbramsMApplication DataMicrosoftExcelXLSTART (where it has been forever)

    I have a custom menu bar for the 20 macros in the personal.xls that works fine.

    Today, all of a sudden, the personal.xls file does not load at Excel startup (of a new worksheet) but does load on a saved worksheet.

    In addition, when I go to Tools/Macro/Macros, it is blank - BUT - I can run them from the custom menu bar !
    After I run a macro from the menu bar, I go back to Tools/Macro/Macros and the macros are then listed !

    This just started happening today - I checked with the network guys and no new updates or patches have been installed for a while.

    This is just weird. Has anyone eles experienced this? Is it fixable?

    Thanks for any insight.

    Michael

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: personal.xls revisited (Excel 2003)

    It looks like Excel has lost or changed the path of its autostart folder.
    You could try recording a new macro in your Personal Macro Workbook, quit Excel and see what happens - does the Personal.xls file at Cocuments and SettingsAbramsMApplication DataMicrosoftExcelXLSTART get updated, or is a new Personal.xls file created in another folder?

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls revisited (Excel 2003)

    when I try that I get an error message:
    Personal Macro Workbook in the startup folder must stay open for recording.
    Click OK
    Unable to record.

    Any ideas?

    Michael

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: personal.xls revisited (Excel 2003)

    Something has gone really wrong. Try Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls revisited (Excel 2003)

    Can you locate your personal.xls? If so, move it out of the xlstart folder and try if you can open it normally.
    If that fails, try the options listed here:
    http://www.jkp-ads.com/articles/corruptfiles.asp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls revisited (Excel 2003)

    Can you locate your personal.xls

    It is two places:
    Cocuments and SettingsAbramsMApplication DataMicrosoftExcelXLSTART
    and
    C:Program FilesMicrosoft OfficeOFFICE11XLSTART

    Is this file supposed to be in both places? If yes, should I move them both out (temporarily?)

    What is most weird, is that this only occurs on a "New" worksheet. Once I run the macro through the menu bar,
    the macros then appear in Macro list!

    All previously saved spreadsheets are fine.

    Michael

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: personal.xls revisited (Excel 2003)

    What are the last modified dates of the two Personal.xls files?

    When you run a macro, Excel will open the workbook in which it is stored. You could do the following:
    - Select Tools | Customize...
    - Right-click a toolbar button that is bound to a macro in Personal.xls.
    - Select Assign macro from the popup menu.
    - Look at the path of the file.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: personal.xls revisited (Excel 2003)

    Try this:
    - Quit all instances of Excel.
    - Move the Personal.xls workbook in Cocuments and SettingsAbramsMApplication DataMicrosoftExcelXLSTART to another folder, e.g. your My Documents folder.
    - Copy the Personal.xls workbook from C:Program FilesMicrosoft OfficeOFFICE11XLSTART to Cocuments and SettingsAbramsMApplication DataMicrosoftExcelXLSTART.
    - Start Excel and see if the macros are available from the start.

  9. #9
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls revisited (Excel 2003)

    Edited by HansV to replace Word document with the picture it contained.

    What are the last modified dates of the two Personal.xls files?

    Cocuments and SettingsAbramsMApplication DataMicrosoftExcelXLSTART = 1/29/09 1:32PM

    C:Program FilesMicrosoft OfficeOFFICE11XLSTART = 1/29/09 1:45PM

    When you run a macro, Excel will open the workbook in which it is stored. You could do the following:
    - Select Tools | Customize...
    - Right-click a toolbar button that is bound to a macro in Personal.xls.
    - Select Assign macro from the popup menu.
    - Look at the path of the file.

    See attached - I do not see a path listed.

    Would it be easiest if I had my IT people just re-install Excel?

    Michael
    Attached Images Attached Images

  10. #10
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls revisited (Excel 2003)

    These are the types of things that cause premature graying.

    It still does not work - but I can still run macros using the custom menu bar. Then the macros are there.

    Wow....

    Thanks Hans for trying - do you think a re-install of Excel would solve this?

    Michael

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: personal.xls revisited (Excel 2003)

    Before you take that step, let's try something else:
    - Start Excel.
    - Run a macro from your custom menu bar to make the macros available.
    - Activate the Visual Basic Editor (Alt+F11).
    - Look at the Project Explorer on the left hand side.
    - You should see your new workbook Book1 - actually, it says VBAProject (Book1) - and at least one other workbook.
    - Is the other one named Personal.xls?
    - If so, activate the Immediate window, and type

    ? Workbooks("Personal.xls").FullName

    - Press Enter and note the result.
    - If there is no Personal.xls in the Project Explorer, what's the name of the other workbook?

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: personal.xls revisited (Excel 2003)

    Re Hans' third step, did you copy the workbook from one folder to the other or did you move it? You need to move it so that you only have one Personal.xls file in one XLSTART directory.
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls revisited (Excel 2003)

    Yes Rory - I did actually move it. This is crazy !

    Michael

  14. #14
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls revisited (Excel 2003)

    Edited by HansV to replace Word doc with the picture it contained - less clicking for those who read the thread

    Immediate window results:
    ?Workbooks("Personal.xls").FullName
    C:Program FilesMicrosoft OfficeOFFICE11xlstartPersonal.xls

    See attached for Project Explorer

    Michael
    Attached Images Attached Images

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: personal.xls revisited (Excel 2003)

    Could you try the following?
    - Select Start | Run...
    - Type regedit and press Enter or click OK.
    - Navigate to HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0Common General
    - The right hand pane should contain a value named Xstart. What is its value?

    (On my PC, with Office XP aka Office 10.0, its value is XLSTART, meaning that Excel uses the default location.)
    Attached Images Attached Images
    • File Type: png x.png (5.5 KB, 0 views)

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •