| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace all formulas with values in multiple worksheets
I have 4 65MB excel 2003 workbooks, each with 125 sheets of data. Each sheet
has multiple array and non-array formulas filled down for 100 rows x 20 columns. I need to email these workbooks, but when zipped, each is still over 7MB. Is there an easy way to remove all formulas in all worksheets at one time, but still leave the final calculated values? Using paste specialvalues one worksheet at a time would be a huge chore. -- JM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas for multiple worksheets | Excel Worksheet Functions | |||
| Find/Replace in multiple worksheets | Excel Discussion (Misc queries) | |||
| Replace soemthing in multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I find and replace null values in Excel 2002 worksheets? | Excel Worksheet Functions | |||
| changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) | |||
Threaded Mode
