View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default 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