Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVING FORMULAS
I have a regular daily exercise to submit a report without any formula and
therefore have to copy all the data and paste special values of the same. Any shortcut to break such links/formulas in a single snap for: 1. The active sheet only? and 2. The whole workbook? -- Best Regards, FARAZ A. QURESHI |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVING FORMULAS
You could put these macros in your Personal.xls workbook (or any workbook
that you could open along with the workbook to be altered) and set up shortcuts to them: Sub FormulaToValue1Sheet() ActiveSheet.UsedRange.Copy ActiveSheet.UsedRange.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub Sub FormulaToValueAllSheets() Dim anySheet As Worksheet For Each anySheet In ActiveWorkbook.Worksheets anySheet.UsedRange.Copy anySheet.UsedRange.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Next End Sub "FARAZ QURESHI" wrote: I have a regular daily exercise to submit a report without any formula and therefore have to copy all the data and paste special values of the same. Any shortcut to break such links/formulas in a single snap for: 1. The active sheet only? and 2. The whole workbook? -- Best Regards, FARAZ A. QURESHI |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVING FORMULAS
Hi there,
a quick way of breaking the links is by doing the following and the values only are left: in 2003 Click Edit, Links then Break Links. or in 2007 click Data, Connections, Edit Links, Break Link Hope this helps. The only way I know to replace formulas however is what you are doing but somebody else here may have a better way. Rgds, Teddy "FARAZ QURESHI" wrote: I have a regular daily exercise to submit a report without any formula and therefore have to copy all the data and paste special values of the same. Any shortcut to break such links/formulas in a single snap for: 1. The active sheet only? and 2. The whole workbook? -- Best Regards, FARAZ A. QURESHI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REMOVING WORKBOOK'S ALL FORMULAS | Excel Discussion (Misc queries) | |||
vlookup - removing formulas | Excel Discussion (Misc queries) | |||
How do I go about finding and removing labels in formulas? | Excel Discussion (Misc queries) | |||
Removing labels and names in formulas | Excel Discussion (Misc queries) | |||
Pasting data without removing formulas | Excel Discussion (Misc queries) |