How can I make appear, within the Pivot table field list, the Fi

Resolved · Medium Priority · Version 365

Tue 23 Aug 2022, 16:41 Delegate Giovanni said...

Giovanni has attended:
Excel Advanced course

How can I make appear, within the Pivot table field list, the Fi

In my PIVOT tables, XLS 365, the search bar in the PIVOT fields list tends to disappear. How can I make it reappear ?

Wed 24 Aug 2022, 15:17 Trainer Jens said...

RE: How can I make appear, within the Pivot table field list, th

Hi Giovanni,

I am sorry but it is a mystery why your search box has disappeared.

If you select the PivotTable and top right on the PivotTable Analyse tab click Field List in the Show group, the field list disappear.

If you then right click on the PivotTable and click the option Show Field list, the field list will show again.

Sorry to be honest I do not think the method works, but I read in a forum that this will reset the field list and the search box will be back.

It sound more to me that you have a buck in your Excel.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 24 Aug 2022, 15:23 Delegate Giovanni said...

RE: How can I make appear, within the Pivot table field list, th

Hello Jens,
I tried the trick, but it didn`t work for me.
I guess it`s a bug.

thanks for trying

G

Wed 24 Aug 2022, 15:23 Delegate Giovanni said...

RE: How can I make appear, within the Pivot table field list, th

Hello Jens,
I tried the trick, but it didn`t work for me.
I guess it`s a bug.

thanks for trying

G

Wed 24 Aug 2022, 15:34 Trainer Jens said...

RE: How can I make appear, within the Pivot table field list, th

Hi Giovanni,

You are welcome. I am sorry that I couldn't be more helpful.

I will come back to you if one of my colleagues know a solution.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 31 Aug 2022: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips