Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I save the formulas, not the data
- Thread starter lsixt
- Start date
Databaseguy
MIS
Cut/Paste Special. There's a choice there for what you want to save Tyrone Lumley
augerinn@gte.net
augerinn@gte.net
- Thread starter
- #3
Databaseguy
MIS
Are you sure you copied or cut somthing first ?? Tyrone Lumley
augerinn@gte.net
augerinn@gte.net
- Thread starter
- #5
DaleWatson123321
Programmer
Hi Isixt,
Ty's suggestion is a good one. But another, possibly preferable option, depending on your application, is to simply use "File Save As" - to save the "entire same file" under a DIFFERENT name.
You mentioned a "template", so perhaps save the file as something like "template_(YourApplicationName).xls". Then, delete the data, but leave all the formulas, AND any other "instruction related information" you perhaps also had included in the original file.
Of course, once the data is deleted, re-save the file under the new template name. And, each time you want to use the template file for a new set of data, again use "File Save As" to save the file (with the new data) under a unique filename. This way, the template file ALWAYS remains WITHOUT data and ready for re-use.
I hope this helps.
Reminder: You thanked Ty (Databaseguy) in your response, but you "forgot" to also show your appreciation by giving him a "STAR". If you are relatively new to Tek-Tips, you might not be aware of the ability to show appreciation. This is done by simply clicking on the "Let _________ know that this post was helpful" - which is located in the lower-left corner of the contributor's posting.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
Ty's suggestion is a good one. But another, possibly preferable option, depending on your application, is to simply use "File Save As" - to save the "entire same file" under a DIFFERENT name.
You mentioned a "template", so perhaps save the file as something like "template_(YourApplicationName).xls". Then, delete the data, but leave all the formulas, AND any other "instruction related information" you perhaps also had included in the original file.
Of course, once the data is deleted, re-save the file under the new template name. And, each time you want to use the template file for a new set of data, again use "File Save As" to save the file (with the new data) under a unique filename. This way, the template file ALWAYS remains WITHOUT data and ready for re-use.
I hope this helps.
Reminder: You thanked Ty (Databaseguy) in your response, but you "forgot" to also show your appreciation by giving him a "STAR". If you are relatively new to Tek-Tips, you might not be aware of the ability to show appreciation. This is done by simply clicking on the "Let _________ know that this post was helpful" - which is located in the lower-left corner of the contributor's posting.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
- Status
Similar threads
- Locked
- Question
- Locked
- Question