The evil Template Wizard troubles me... even in my sleep! :(
 

We have several workborks here that report, "This workbook was not created
using the template wizard." when attempting to save.

Great! Who cares? :P

Can someone please tell me how to do away with this annoyance?

Thanks!

--
-Mike Mertes
Airtron, Tampa Bay

The evil Template Wizard troubles me... even in my sleep! :(
 

Mike

I don't know all the reasons that could happen, but I do know one. If you
create a workbook from a template that was created with the Template Wizard,
it will have a Sheet2 that is hidden. Sheet2 contains all of the database
information. If you delete Sheet2, then try to save that workbook, you'll
get that message.

Somehow the workbook says it still has macros, but I don't see any. There's
some connection with the original template though that's trying to write to
the database.

Two ways to fix: Tools Add-ins and uncheck Template Wizard with Data
Tracking if you never use that feature. The other way is to copy the
contents of that workbook to a new, clean workbook. I'm sure you can just
copy the visible sheets.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Mike Mertes" wrote in message
...
We have several workborks here that report, "This workbook was not created
using the template wizard." when attempting to save.

Great! Who cares? :P

Can someone please tell me how to do away with this annoyance?

Thanks!

--
-Mike Mertes
Airtron, Tampa Bay

The evil Template Wizard troubles me... even in my sleep! :(
 

Thanks :)

That information will help me well.

--
-Mike Mertes
Airtron, Tampa Bay

The evil Template Wizard troubles me... even in my onesleep! :(
 

Perhaps DK can tell me where to find the specific ad-in entitled "Template
Wizard with Data Tracking" which I have used before on another stand-alone
PC, but which now seems to have disappeared from both laptop and Microsoft XP
Professional CD. When I re-install from the CD it simply does not appear in
the Tools drop-down list.

"Dick Kusleika" wrote:

Mike

I don't know all the reasons that could happen, but I do know one. If you
create a workbook from a template that was created with the Template Wizard,
it will have a Sheet2 that is hidden. Sheet2 contains all of the database
information. If you delete Sheet2, then try to save that workbook, you'll
get that message.

Somehow the workbook says it still has macros, but I don't see any. There's
some connection with the original template though that's trying to write to
the database.

Two ways to fix: Tools Add-ins and uncheck Template Wizard with Data
Tracking if you never use that feature. The other way is to copy the
contents of that workbook to a new, clean workbook. I'm sure you can just
copy the visible sheets.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Mike Mertes" wrote in message
...
We have several workborks here that report, "This workbook was not created
using the template wizard." when attempting to save.

Great! Who cares? :P

Can someone please tell me how to do away with this annoyance?

Thanks!

--
-Mike Mertes
Airtron, Tampa Bay

The evil Template Wizard troubles me... even in my onesleep! :(
 

It is no longer distributed with Excel.

http://support.microsoft.com/default...b;en-us;288118
Add-ins that are not included with Excel 2002 and Excel 2003

tells how to get them.

addins


--
Regards,
Tom Ogilvy


"pumicestone" wrote in message
...
Perhaps DK can tell me where to find the specific ad-in entitled "Template
Wizard with Data Tracking" which I have used before on another stand-alone
PC, but which now seems to have disappeared from both laptop and Microsoft
XP
Professional CD. When I re-install from the CD it simply does not appear
in
the Tools drop-down list.

"Dick Kusleika" wrote:

Mike

I don't know all the reasons that could happen, but I do know one. If
you
create a workbook from a template that was created with the Template
Wizard,
it will have a Sheet2 that is hidden. Sheet2 contains all of the
database
information. If you delete Sheet2, then try to save that workbook,
you'll
get that message.

Somehow the workbook says it still has macros, but I don't see any.
There's
some connection with the original template though that's trying to write
to
the database.

Two ways to fix: Tools Add-ins and uncheck Template Wizard with Data
Tracking if you never use that feature. The other way is to copy the
contents of that workbook to a new, clean workbook. I'm sure you can
just
copy the visible sheets.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Mike Mertes" wrote in message
...
We have several workborks here that report, "This workbook was not
created
using the template wizard." when attempting to save.

Great! Who cares? :P

Can someone please tell me how to do away with this annoyance?

Thanks!

--
-Mike Mertes
Airtron, Tampa Bay