ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Personal.xls won't start automatically (https://www.excelbanter.com/excel-programming/292923-personal-xls-wont-start-automatically.html)

Shatin

Personal.xls won't start automatically
 
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 Wright

Personal.xls won't start automatically
 
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



Bob Phillips[_6_]

Personal.xls won't start automatically
 
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?





Shatin

Personal.xls won't start automatically
 
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





Dave Peterson[_3_]

Personal.xls won't start automatically
 
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


Bob Phillips[_6_]

Personal.xls won't start automatically
 
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




Shatin

Personal.xls won't start automatically
 
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[_3_]

Personal.xls won't start automatically
 
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


Dave Peterson[_3_]

Personal.xls won't start automatically
 
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


Ken Wright

Personal.xls won't start automatically
 
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



Jon Peltier

Personal.xls won't start automatically
 
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





Jon Peltier

Personal.xls won't start automatically
 
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



Ken Wright

Personal.xls won't start automatically
 
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



Dave Peterson[_3_]

Personal.xls won't start automatically
 
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



All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com