Undo "Convert to formulas" pivot function

T

Tomas

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Doughnut Chart linked with the slicer in the pivot table 0
OLAP Pivot Table 1
Convert Pivot to Table w Formulas 0
Excel 2007 pivot table using analysis services cube as data source 0
To make pdf to work as word 1
Pivot Table refresh question 0

Top