| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easily convert all formulas in 3d spreadsheet to values?
I have a large Excel 3-D workbook with 40 sheets, each with multiple complex
formulas. At the end of each month I archive the sheet and would like to convert the formulas into values to reduce the size of the workbook. Can this be done in a few easy steps, as I don't want to copy and special paste as values 40 times over? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simplify procedure to get rid of 0 error values in a spreadsheet | Excel Worksheet Functions | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
| changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) | |||
| I created a spreadsheet in excel & trying to convert it to micros. | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
