Move or Lock Excel Pivot Table Field List

See how you can adjust an Excel Pivot Table Field List's layout, width, and position.
You can move the list so it floats over the worksheet, or lock it at the side of the worksheet
Get written steps and an Excel sample file on my Contextures site.
www.contextures.com/excelpivo...
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: www.contextures.com/signup01
More Excel Tips and Tutorials: www.contextures.com/tiptech.html
Subscribe to Contextures RUclips: ruclips.net/user/contextu...
#ContexturesExcelTips

[@pipo441]

Hi Debra, hope all is well. I have the same calculated field formula that I used in a couple of pivot tables. A sudden it doesn't calculate anymore. Tried to re-enter the formula but no success. It only work for one pivot table but in the other pivot tables no result shows up at all. Any thought? Thank you.

[@contextures]

Thanks, Pipo, and it's hard to guess what the problem is. If you ask in one of the Excel forums, where you can upload your file, someone might be able to help

[@pipo441]

It look as I have created too many calculated fields and pivot tables.... Does that make sense? @@contextures

[@contextures]

@@pipo441 Again, it's hard to guess.

[@pipo441]

@@contextures I solved the issue. In the master data table I removed the formulas in the relevant column hit save button and then re-entered the same formula again and now calculated field works again. Must be some bug. FYI there was no error in the initial formula.

[@contextures]

@@pipo441That's strange! I'm glad you solved the problem, and thanks for letting me know how you fixed it.

[@ataman4100]

Double click does not work