Excel 2007 startup file won’t load anymore

Topic

New Reply

I have Excel 2007 set to load at startup all files in:
C:Program Files (x86)Microsoft OfficeOffice12XLSTART

It is a trusted location. Macro setting set to “Enable all…”

I have a file PERSONAL.xLSB in: C:Program Files (x86)Microsoft OfficeOffice12XLSTART

It used to load and now it doesn’t. If I physically load it, it works.

Any suggestions on how to fix this irritation?

Thanks.

Reply | Quote

Replies

Check under Disabled items in the addins section of the Excel Options.

Reply | Quote

Nothing disabled

Reply | Quote

What do you mean by “I have Excel 2007 set to load at startup all files in:
C:Program Files (x86)Microsoft OfficeOffice12XLSTART”?

That is the default and not something you need to set up.
You don’t by any chance have 2 personal macro workbooks in separate folders do you?

Reply | Quote

What do you mean by “I have Excel 2007 set to load at startup all files in:
C:Program Files (x86)Microsoft OfficeOffice12XLSTART”?

Under Excel Options/Advanced/”At startup, open all files in” is set to C:Program Files (x86)Microsoft OfficeOffice12XLSTART
Removed the directory entry and it made no difference.

That is the default and not something you need to set up.
You don’t by any chance have 2 personal macro workbooks in separate folders do you?

I have one copy of Personal.xlsb in C:Miscellaneous Dataexcelpersonal excel macro folder in addition to the XLSTART folder.

Thanks for the help!

Reply | Quote