Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
C. David Rossen
 
Posts: n/a
Default Personal.xls does not open

Hello:

For some reason, when I start Excel, the file personal.xls does not open
anymore, not even hidden. I want to be able to save macros to it, but it
does not list that as an option anymore. The file that opens is Book1.
Personal.xls is in the xlstart directory. Thanks.

David


  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

It is possible that Excel encountered a problem with the file. Go
to the Help menu, choose About Excel, and click the Disabled
Items button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"C. David Rossen" wrote in message
...
Hello:

For some reason, when I start Excel, the file personal.xls does
not open
anymore, not even hidden. I want to be able to save macros to
it, but it
does not list that as an option anymore. The file that opens is
Book1.
Personal.xls is in the xlstart directory. Thanks.

David




  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

xl2002+ have the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you'll want to put your backup copy in XLStart.

"C. David Rossen" wrote:

Hello:

For some reason, when I start Excel, the file personal.xls does not open
anymore, not even hidden. I want to be able to save macros to it, but it
does not list that as an option anymore. The file that opens is Book1.
Personal.xls is in the xlstart directory. Thanks.

David


--

Dave Peterson
  #4   Report Post  
C. David Rossen
 
Posts: n/a
Default

Thanks...that worked.


"Chip Pearson" wrote in message
...
It is possible that Excel encountered a problem with the file. Go
to the Help menu, choose About Excel, and click the Disabled
Items button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"C. David Rossen" wrote in message
...
Hello:

For some reason, when I start Excel, the file personal.xls does
not open
anymore, not even hidden. I want to be able to save macros to
it, but it
does not list that as an option anymore. The file that opens is
Book1.
Personal.xls is in the xlstart directory. Thanks.

David






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to open excel sheet in Protected mode from VB 6.0 ourspt Setting up and Configuration of Excel 0 January 26th 05 11:07 AM
Personal.xls and Excel.xlb Terry Excel Discussion (Misc queries) 1 January 26th 05 01:49 AM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM
How do I get my personal macro worksheet to open whenever I open . Claudia_R Excel Discussion (Misc queries) 3 December 9th 04 11:59 PM
Cannot open a file that Excel says is open Plodhia Excel Discussion (Misc queries) 2 December 7th 04 01:43 AM


All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"