View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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