My understanding is that the personal.xls is supposed to open at start up
automatically. Don't know why but my doesn't. It's placed in this directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and put
the above path into the textbox. Still the same result, personal.xls just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

Personal.xls is a hidden worksheet, so take a look at Window / Unhide and see if
it is there.

You usually store bits of macro code and other snippets in there, but leave it
hidden as a general rule.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Shatin" wrote in message
...
My understanding is that the personal.xls is supposed to open at start up
automatically. Don't know why but my doesn't. It's placed in this directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and put
the above path into the textbox. Still the same result, personal.xls just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004

Shatin,

Are you sure it is not just hidden.

Goto WindowUnhide and see if it is there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Shatin" wrote in message
...
My understanding is that the personal.xls is supposed to open at start up
automatically. Don't know why but my doesn't. It's placed in this
directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and
put
the above path into the textbox. Still the same result, personal.xls just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

Ken and Bob,

No, the personal.xls is not hidden. It's just not opened automatically. I
use the file all the time and so have unhidden it, it's just that I have to
open the file manually. And even when I hide personal.xls, the file will
still not open.

What is strange is that, I just used Rob Bovey's VBA Documentor to document
the personal.xls. A report file was generated and put into the Xlstart
directory. This report file does open automatically. It's just the
personal.xls that refuses to open.

"Ken Wright" wrote in message
...
Personal.xls is a hidden worksheet, so take a look at Window / Unhide and
see if
it is there.

You usually store bits of macro code and other snippets in there, but
leave it
hidden as a general rule.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Shatin" wrote in message
...
My understanding is that the personal.xls is supposed to open at start
up
automatically. Don't know why but my doesn't. It's placed in this
directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and
put
the above path into the textbox. Still the same result, personal.xls
just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004

If it really isn't opening (after you've checked for a hidden workbook), try
Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are damaged.
And it's easy to just click on "yes" to the "do you want the offending workbook
disabled".

But if excel was really correct that your workbook is damaged, you may have to
use your backup copy.

Shatin wrote:

My understanding is that the personal.xls is supposed to open at start up
automatically. Don't know why but my doesn't. It's placed in this directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and put
the above path into the textbox. Still the same result, personal.xls just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

--

Dave Peterson

aah yes, the backups. I'll just get my off-site backups now <vbg

Bob

"Dave Peterson" wrote in message
...
If it really isn't opening (after you've checked for a hidden workbook),
try
Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are
damaged.
And it's easy to just click on "yes" to the "do you want the offending
workbook
disabled".

But if excel was really correct that your workbook is damaged, you may
have to
use your backup copy.

Shatin wrote:

My understanding is that the personal.xls is supposed to open at start
up
automatically. Don't know why but my doesn't. It's placed in this
directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and
put
the above path into the textbox. Still the same result, personal.xls
just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

--

Dave Peterson

Dave,

You are absolutely right. The workbook was indeed quarantined. I am not
exactly sure why. I used Excel 97 until a few months ago and I had the
personal.xls while still using '97. Perhaps this is the reason??? As I
mentioned in another post, I have been using the personal.xls all the time
by opening it manually without problem and so am puzzled why Excel felt it
should be quarantined.

Anyway, the file opens automatically now. Many thanks for your help!

"Dave Peterson" wrote in message
...
If it really isn't opening (after you've checked for a hidden workbook),
try
Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are
damaged.
And it's easy to just click on "yes" to the "do you want the offending
workbook
disabled".

But if excel was really correct that your workbook is damaged, you may
have to
use your backup copy.

Shatin wrote:

My understanding is that the personal.xls is supposed to open at start
up
automatically. Don't know why but my doesn't. It's placed in this
directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and
put
the above path into the textbox. Still the same result, personal.xls
just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

--

Dave Peterson

It's not just because it came from xl97. Excel thought that there was something
wrong with it.

I've seen excel be mistaken, but I'd make sure that I had a backup
available--just in case it becomes a recurring theme.

Shatin wrote:

Dave,

You are absolutely right. The workbook was indeed quarantined. I am not
exactly sure why. I used Excel 97 until a few months ago and I had the
personal.xls while still using '97. Perhaps this is the reason??? As I
mentioned in another post, I have been using the personal.xls all the time
by opening it manually without problem and so am puzzled why Excel felt it
should be quarantined.

Anyway, the file opens automatically now. Many thanks for your help!

"Dave Peterson" wrote in message
...
If it really isn't opening (after you've checked for a hidden workbook),
try
Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are
damaged.
And it's easy to just click on "yes" to the "do you want the offending
workbook
disabled".

But if excel was really correct that your workbook is damaged, you may
have to
use your backup copy.

Shatin wrote:

My understanding is that the personal.xls is supposed to open at start
up
automatically. Don't know why but my doesn't. It's placed in this
directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and
put
the above path into the textbox. Still the same result, personal.xls
just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

--

Dave Peterson


--

Dave Peterson

I have my personal.xla backed up in a couple of folders (at home and at
work)--in a zip file version, too. It's on a couple of those thumbdrives--just
stopped backing up to floppy.

Too much work (well, by others--copying and pasting from the NG's is my
responsibility <bg) to lose!





Bob Phillips wrote:

aah yes, the backups. I'll just get my off-site backups now <vbg

Bob

"Dave Peterson" wrote in message
...
If it really isn't opening (after you've checked for a hidden workbook),
try
Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are
damaged.
And it's easy to just click on "yes" to the "do you want the offending
workbook
disabled".

But if excel was really correct that your workbook is damaged, you may
have to
use your backup copy.

Shatin wrote:

My understanding is that the personal.xls is supposed to open at start
up
automatically. Don't know why but my doesn't. It's placed in this
directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and
put
the above path into the textbox. Still the same result, personal.xls
just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

--

Dave Peterson


--

Dave Peterson

I've replicated the damn thing on every drive I've got, including a USB pendrive
as well. I go all cold and shivery if I can't access my damn file (On someone
else's machine for example), and the thought of losing it..............
<shivers

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Dave Peterson" wrote in message
...
I have my personal.xla backed up in a couple of folders (at home and at
work)--in a zip file version, too. It's on a couple of those
thumbdrives--just
stopped backing up to floppy.

Too much work (well, by others--copying and pasting from the NG's is my
responsibility <bg) to lose!





Bob Phillips wrote:

aah yes, the backups. I'll just get my off-site backups now <vbg

Bob

"Dave Peterson" wrote in message
...
If it really isn't opening (after you've checked for a hidden workbook),
try
Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are
damaged.
And it's easy to just click on "yes" to the "do you want the offending
workbook
disabled".

But if excel was really correct that your workbook is damaged, you may
have to
use your backup copy.

Shatin wrote:

My understanding is that the personal.xls is supposed to open at start
up
automatically. Don't know why but my doesn't. It's placed in this
directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and
put
the above path into the textbox. Still the same result, personal.xls
just
won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

--

Dave Peterson


--

Dave Peterson



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004

Too much work (well, by others--copying and pasting from the NG's is
my responsibility <bg) to lose!

LOL! You too, eh?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______


Dave Peterson wrote:

I have my personal.xla backed up in a couple of folders (at home and at
work)--in a zip file version, too. It's on a couple of those thumbdrives--just
stopped backing up to floppy.

Too much work (well, by others--copying and pasting from the NG's is my
responsibility <bg) to lose!





Bob Phillips wrote:

aah yes, the backups. I'll just get my off-site backups now <vbg

Bob

"Dave Peterson" wrote in message
...

If it really isn't opening (after you've checked for a hidden workbook),

try

Help|About Microsoft Excel|and click on disabled items.

xl2002 added a "quarantine" function for workbooks that it thinks are

damaged.

And it's easy to just click on "yes" to the "do you want the offending

workbook

disabled".

But if excel was really correct that your workbook is damaged, you may

have to

use your backup copy.

Shatin wrote:

My understanding is that the personal.xls is supposed to open at start

up

automatically. Don't know why but my doesn't. It's placed in this

directory:

c:\Program Files\Microsoft Office\OFFICE11\XLSTART\

So I choose "Tools|Option|General|At start up, open all files in: " and

put

the above path into the textbox. Still the same result, personal.xls

just

won't be opened at start up.

I wonder what the problem is. Have I changed some setting inadvertently?

--

Dave Peterson

I just started rebuilding mine. I took out a bunch of semideveloped
things that I no longer need, and Excel starts up much faster. I have
dozens of backups everywhere, and I never know which might have that
interesting thing I was working on.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Ken Wright wrote:

I've replicated the damn thing on every drive I've got, including a USB pendrive
as well. I go all cold and shivery if I can't access my damn file (On someone
else's machine for example), and the thought of losing it..............
<shivers

LOL - rebuilding when you have access to your current bloated files, and
therefore a wealth of choice is one thing, but the thought of rebuilding from
scratch by having to search all that good stuff out again - Aaaagghh -
Nightmareeeeeee!!!!

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Jon Peltier" wrote in message
...
I just started rebuilding mine. I took out a bunch of semideveloped
things that I no longer need, and Excel starts up much faster. I have
dozens of backups everywhere, and I never know which might have that
interesting thing I was working on.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Ken Wright wrote:

I've replicated the damn thing on every drive I've got, including a USB
pendrive
as well. I go all cold and shivery if I can't access my damn file (On
someone
else's machine for example), and the thought of losing it..............
<shivers




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.605 / Virus Database: 385 - Release Date: 01/03/2004

If I had a Help|About, I'd have too many names to mention. And that alone
really slow down excel <vbg.

Jon Peltier wrote:

Too much work (well, by others--copying and pasting from the NG's is
my responsibility <bg) to lose!

LOL! You too, eh?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______


--

Dave Peterson