Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to save a copy of a wksht. but without any of the formulas
Is there a trick to saving a worksheet keeping all values but erasing the
formulas behind the cells? I have been copying a excel workbook that others in my company edit and displaying our content on SharePoint. My company owns a version of SPoint that doesn't support many of Excel's features used in creations of workbooks, thus leaving me with editing out lots of things (Even IMAGES!). haha. But my question is, can i easily take out formulas, vlookups, macros, or other things and still preserve the cell contents as they are even when the values rely on other sheets or looking up something in other cells with formulas? thanks! Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1st 2 rows of wksht show up @ top of each page of the wksht | Excel Discussion (Misc queries) | |||
Macro to Copy/Paste Data into one wksht, skipp one row before past | Excel Discussion (Misc queries) | |||
Can I copy page set ups in Excel 2003 from one wksht to another | Excel Worksheet Functions | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions |