- Jan 20, 2021
- Office Version
Hi Everyone, I have question regarding pivot. Is there a way in excel to lock the pivot field setting layout? Because whenever I delete the raw data and save it and open again and try to import new one, the settings changed. If you see on the image, that is the settings that I need but what happen is it goes to Show item labels in outline form (first option)., I have 5 pivot on that sheets and have the same issue.