| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Undo "Convert to formulas" pivot function
Hi
I have a pivot table which uses data from an OLAP AS-cube. In some cases I need to convert the pivot table to formulas using the function "convert to formulas". Q: Is it possible to UNDO "convert to formulas" and go back to a a OLAP pivot table? regards Tomas |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Undo "Convert to formulas" pivot function
Is Edit|Undo still available?
When I do this kind of stuff, I'll copy the worksheet with the pivottable. Then work on that copy. When I screw it up, I'll just delete that copied sheet and make a new copy. Tomas wrote: Hi I have a pivot table which uses data from an OLAP AS-cube. In some cases I need to convert the pivot table to formulas using the function "convert to formulas". Q: Is it possible to UNDO "convert to formulas" and go back to a a OLAP pivot table? regards Tomas -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
| function to convert number to words [ 21 = "twenty one " ] | Excel Worksheet Functions | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
Linear Mode
