Why Undo and Redo button are disabled in my Pivot

S

Shailesh

Can any one please suggest me why I am not getting UNDO and REDO
button on my Pivot table.
I just want to add that I have put a small VBA code which dynamically
changes the formula for a calculated field in Worksheet_calculate Sub.
How ever I have noticed that if I remove the VBA code I get these
buttons back.
But I can not remove this code as this is giving me one important
calculated field.

Can any one suggest me how to get it back?
 

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

after installing auto-save, lost redo function but kept undo 1
UNDO and REDO buttons are inactive 7
loss of redo function after installing auto-save 1
Inactive UNDO REDo button due to a macro 2
redo function loss after auto-save (just installed) activates. 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Slicers and Calculated Items in Pivot Table 2
How do I reactivate my undo and redo functions in Excel? 1

Top