Template Help

[Dee]

I created an Excel 2000 Template with a linked Database
using the Template Wizard add-in. I need to remove the
Database from this Template. I have deleted sheets, saved
under a new name, copied and pasted the workbook and I
still get the Databse link pop up everytime I close the
workbook! How can I remove this link??

 

[Dick Kusleika]

Dee

The Data Tracker uses a hidden sheet named Template Information. If you
copy all the visible sheets to a new workbook, the new workbook will not be
linked to the database. Then you can save the new workbook over the old
one.