| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value a workbook
Hello
Is there a way to value a workbook all at once. I have a workbook that has 25 workshheets. Everymonth I update the report save it as (v1) then value every worksheet one by one. Is there a way to value the a workbook at once instead sheet by sheet Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Value a workbook
Do you mean that you convert the formulae in those sheets to values
using <copy then Edit | Paste Special | Values ? Pete On Aug 19, 3:09*pm, Wanna Learn wrote: Hello Is there a way to value a workbook all at once. * I have a workbook that has 25 workshheets. *Everymonth I update the report save it as (v1) then value every worksheet one by one. * Is there *a way to value the a workbook at once instead sheet by sheet Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Value a workbook
Thanks Pete
Yes that is what I do for each sheet <copy then Edit | Paste Special | Values "Pete_UK" wrote: Do you mean that you convert the formulae in those sheets to values using <copy then Edit | Paste Special | Values ? Pete On Aug 19, 3:09 pm, Wanna Learn wrote: Hello Is there a way to value a workbook all at once. I have a workbook that has 25 workshheets. Everymonth I update the report save it as (v1) then value every worksheet one by one. Is there a way to value the a workbook at once instead sheet by sheet Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Value a workbook
You could use a macro that loops through each worksheet and does edit|copy,
edit|paste special|values. But you could try this, too. Select all the worksheets in the workbook (rightclick on one worksheet tab and choose select all sheets) Then select all the cells in that sheet (ctrl-a a few times) edit|copy edit|paste special|values Then ungroup the sheets (rightclick on one of the selected tabs and choose ungroup sheets) Then check the results. If it worked, ok. If not, then close without saving -- or hit edit|undo! Wanna Learn wrote: Hello Is there a way to value a workbook all at once. I have a workbook that has 25 workshheets. Everymonth I update the report save it as (v1) then value every worksheet one by one. Is there a way to value the a workbook at once instead sheet by sheet Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
| Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Hybrid Mode
