personal.xls in 2007

  • Thread starter Thread starter wal
  • Start date Start date
W

wal

Excel 2007
Vista Enterprise SP1

In what folder is personal.xls supposed to go in Vista Enterprise?
Currently, it's in:

C:\Users\<MyFolderName>\AppData\Roaming\Microsoft\Excel\XLSTART

How do I ensure that personal.xls will automatically be invoked
(opened but hidden) whenever I open an Excel worksheet? This isn't
happening automatically as it does with XP.

(Do I need to convert it to .xlsx? But note that we are currently
saving everything by default as .xls for the time being.)

Thanks.
 
Answer to self: I saved PERSONAL.XLS as PERSONAL.XLSM. The location
seems fine.

Now, when I open an existing worsheet, personal.xlsm also opens (and
I've set it to be Hidden).

However, when I open Excel itself from a general Excel desktop icon,
the program opens, with personal.xlsm hidden, but no fresh workbook
open. How can I start Excel so that both personal.xlsm and a blank
workbook both open?

Thanks.
 
It is xlsb

See
http://www.rondebruin.nl/personal.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Answer to self: I saved PERSONAL.XLS as PERSONAL.XLSM. The location
seems fine.

Now, when I open an existing worsheet, personal.xlsm also opens (and
I've set it to be Hidden).

However, when I open Excel itself from a general Excel desktop icon,
the program opens, with personal.xlsm hidden, but no fresh workbook
open. How can I start Excel so that both personal.xlsm and a blank
workbook both open?

Thanks.
 
Ron,

Thanks.

What is xslm vs. xlsb? The effect you describe on your webpage also
occurs with my personal.xlsm, and its macros do work. So does it make
any difference?

Also, and maybe I didn't read your page carefully enough, but how do I
also get a blank (non-personal.xlsm/b) workbook to appear
automatically upon starting Excel, in addition to the hidden
personal.xlsm/b? Thanks.
 
xlsb load faster then xlsm

First remove the personal file you have now from xlstart

If you create a personal file (see steps on my page) it will open
a empty workbook for you when you start excel

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Ron,

Thanks.

What is xslm vs. xlsb? The effect you describe on your webpage also
occurs with my personal.xlsm, and its macros do work. So does it make
any difference?

Also, and maybe I didn't read your page carefully enough, but how do I
also get a blank (non-personal.xlsm/b) workbook to appear
automatically upon starting Excel, in addition to the hidden
personal.xlsm/b? Thanks.
 
Back
Top