Sep 17 2021 03:02 AM
Hi,
I accidentally detached the Pivot Table Fields item from the right side of the Excel screen. Now it's floating and disappears every time the cursor is not set within the pivot table.
How can I fix this and re-anchor the Pivot Table Fields back to the right side of the screen?
Thanks!
Sep 17 2021 03:10 AM
@carinae31585 Just drag it to the right-hand side of the screen and it should "attach" itself again.
Sep 17 2021 03:24 AM
Sep 17 2021 03:32 AM
@carinae31585 Strange. Works on my set-up. But, just to be sure. Drag it all the way to the right, as if you want to drag it off the screen. It snaps back into place as soon as the cross-hair touches the edge of the window. For me at least.
Sep 17 2021 03:42 AM
Sep 17 2021 03:43 AM
Sep 17 2021 04:04 AM
Solution@carinae31585 Never tried to drag it off the Excel window, but that is apparently possible when you drag quickly. I've learned something. But when I drag slowly and hold it with the cross-hair over the edge of the Excel window, it snaps back. If not for you, I've run out of ideas.
Sep 17 2021 04:08 AM
Jun 08 2022 08:48 AM
Jun 08 2022 08:53 AM
Hi,
Thanks for your replies and trying to help. Unfortunately, this happened to me again and now none of the options is working. The pivot table window keeps floating on top, I can still drag it out of the Excel window, and even moving it very slowly doesn't help :(
Jun 08 2022 01:20 PM
Is that with any pane (e.g. Help, whatever) and on any file or only for that specific one?
Jun 09 2022 12:52 AM
Sep 17 2021 04:04 AM
Solution@carinae31585 Never tried to drag it off the Excel window, but that is apparently possible when you drag quickly. I've learned something. But when I drag slowly and hold it with the cross-hair over the edge of the Excel window, it snaps back. If not for you, I've run out of ideas.