Save Excel 2007 as template without the data
Posted on 2011-03-02
I created a workbook from imported data and added pivot tables and charts to it. I want to save the workbook as a macro enabled template without the data, but it only seems to have options to save or refresh data when opened. If I can't save the template without the data, is there a macro I can use to clear all the data? There are 7 worksheets of data and 5 worksheets with tables/charts that use the data. I need to preserve the formatted worksheets and clear the raw data worksheets.
It seems that this should be a standard feature, but I am not able to find it.