Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
The evil Template Wizard troubles me... even in my sleep! :(
Thanks :)
That information will help me well. -- -Mike Mertes Airtron, Tampa Bay |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I distribute a template created with Template Wizard ? | Excel Discussion (Misc queries) | |||
Template Wizard... | Excel Discussion (Misc queries) | |||
Template Wizard | Excel Discussion (Misc queries) | |||
Template or Wizard? | Excel Discussion (Misc queries) | |||
Template Wizard - Add-In | Excel Discussion (Misc queries) |