I have created a pivot table in which one field is calculated field.
I saved and closed this pivot table. Next time when I open it is changing into normal Excel table with values. But I want this to open as pivot as is. How can I rectify this problem? Please help someone.
Application using: Excel 2007.