Worksheets & Formulas & Data
I have a workbook with a large number of worksheets with formulas and
circular references. I would like to save the workbook as a template but that entails removing all the data. Is there any way to remove the data but keep the formulas. |
Worksheets & Formulas & Data
I have not found a way to do that yet, except to manually delete the cells
that are calculated to fill the other cells. I suppose I could write a macro to do that but I never got around to it since my worksheets with that type condition are small. "RJR" wrote: I have a workbook with a large number of worksheets with formulas and circular references. I would like to save the workbook as a template but that entails removing all the data. Is there any way to remove the data but keep the formulas. |
Worksheets & Formulas & Data
F5SpecialConstants.
De-select what you want to save(like Text if you want to retain titles or notes and hit OK. EditClear Contents. Formulas will remain. Gord Dibben MS Excel MVP On Fri, 3 Nov 2006 12:10:01 -0800, RJR wrote: I have a workbook with a large number of worksheets with formulas and circular references. I would like to save the workbook as a template but that entails removing all the data. Is there any way to remove the data but keep the formulas. |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com