Pivot Table Toolbar in Excel 2000

kylster · May 6th, 2002, 03:37 PM

I've used Excel 95 & 97 for years and was able to "dock" the Pivot Table toolbar in the top of the screen with all the other toolbars. Since moving to Excel 2000 (running under Windows 2000) it seems to want to "float" all the time. I can't get it to stay docked.

Any suggestions?

RET79 · May 6th, 2002, 03:39 PM

mine docks !

have you tried clicking right button on the toolbar, choosing pivot table then when you get the thing drag it and drop it on the existing toolbars, when I do that mine docks !

RET79

kylster · May 6th, 2002, 03:45 PM

Yes, it will dock, but if I take a section of data and perform a pivot on it, then the toolbar detatches and moves down into the body of the data.

RET79 · May 6th, 2002, 03:46 PM

that happens on mine too

RET79

Jack in the UK · May 6th, 2002, 03:46 PM

mine docks all ok

when i use pivit it floats. you getting this mixed...

May 6th, 2002, 03:46 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	mine docks all ok when i use pivit it floats. you getting this mixed... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 03:37 PM	#1
kylster New Member Join Date: May 2002 Posts: 8	I've used Excel 95 & 97 for years and was able to "dock" the Pivot Table toolbar in the top of the screen with all the other toolbars. Since moving to Excel 2000 (running under Windows 2000) it seems to want to "float" all the time. I can't get it to stay docked. Any suggestions?

May 6th, 2002, 03:39 PM	#2
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	mine docks ! have you tried clicking right button on the toolbar, choosing pivot table then when you get the thing drag it and drop it on the existing toolbars, when I do that mine docks ! RET79

May 6th, 2002, 03:45 PM	#3
kylster New Member Join Date: May 2002 Posts: 8	Yes, it will dock, but if I take a section of data and perform a pivot on it, then the toolbar detatches and moves down into the body of the data.