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

[Mike Mertes]

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

Great! Who cares?

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

Thanks!

 

[Dick Kusleika]

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.

 

[Mike Mertes]

Thanks

That information will help me well.

 

[Guest]

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.

 

[Tom Ogilvy]

It is no longer distributed with Excel.

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

tells how to get them.

addins