ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   xlstart and exported data (https://www.excelbanter.com/excel-discussion-misc-queries/224722-xlstart-exported-data.html)

Jen

xlstart and exported data
 
Hello, I have created a book and sheet template and have placed this in my
xlstart folder so that when I open excel my custom colors and formatting are
there.

However, when excel is opened by another program, such as exporting a
report, the templates are ignored. Shouldn't excel always use the template
in the xlstart folder?

Thanks,
Jen

Gord Dibben

xlstart and exported data
 
As you have noticed..........when opened from another program, Excel uses
the built-in default "blank workbook"

You will find the same thing if you go to FileNew...Blank Workbook.

Excel will open the default, not your customized.

I know of no way to get around that.


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 06:48:04 -0700, Jen
wrote:

Hello, I have created a book and sheet template and have placed this in my
xlstart folder so that when I open excel my custom colors and formatting are
there.

However, when excel is opened by another program, such as exporting a
report, the templates are ignored. Shouldn't excel always use the template
in the xlstart folder?

Thanks,
Jen




All times are GMT +1. The time now is 02:30 AM.

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