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

OLAP Pivot Table 1
Pivot table layout that popluates the row label in each row? 3
Excel file with olap cube gets corrupted 1
Filter list not correctly refreshed 3
OLAP sum function 2
Referencing a pivot tables Grand Totals Column 1
OLAP Pivot Table Calculations 4
Calculates field in pivot table 2

Top