You are here: Home > Excel > Personal.xls workbook Not Available When You Start Microsoft Excel

Personal.xls workbook Not Available When You Start Microsoft Excel


February 2, 2008 – 3:47 am by JP

If you normally keep your macros in a personal.xls workbook (in your XLSTART folder) but suddenly it doesn’t open, try this technique for restoring it.

I assume you have already checked to make sure it isn’t just hidden (Window>Unhide) or disabled (Help>About Microsoft Excel>Disabled Items).

1. Quit all instances of Microsoft Excel, then press Ctrl-Alt-Del and click the Processes tab (in Win XP).

2. Sort the running processes by filename by clicking on the first header.


3. Look for EXCEL.EXE and, if it is present, click ‘End Process’ and ‘Yes’ to allow the Task Manager to remove Excel from memory.

4. Repeat for any other instances of Excel still present in memory.

5. Open Excel normally and the personal.xls workbook should now open.

Works with:

Excel 2002
Excel 2003
on Win XP

–JP


If you enjoyed this page, share it!
    StumbleUpon Technorati Digg Google del.icio.us MisterWong TwitThis

Print This Post Print This Post  |  Email This Post Email This Post  |  rss Subscribe to Posts Feed  |  rss Subscribe to Comments

Filed Under: Excel
Tags:

Post a Comment


Certain comments are subject to moderation and may not appear immediately. First-time comments are moderated. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, you need to escape those characters. To post VBA code in your comment, use [VBA] tags, like this: [VBA]Code goes here[/VBA].





Subscribe without commenting

Keep Reading:

Browse Posts:


« VBA Macro to Remove Stationery from Email Message || Import data to Access from Excel »

Copyright © 2007,2008 Code For Excel And Outlook || Disclaimer