Deleting an otpion on the drop down menu on a pivot table
I have created a pivot and after amending some of the columns in the data
page. I have then gone to refresh the pivot table. Although there is no longer any cells with the old data the option to select the old data is still being shown although it contains no info |
Hi
Take a look here to see methods for clearing old items both manually and programmatically. http://www.contextures.com/xlPivot04.html Regards Roger Govier Accountant Williams wrote: I have created a pivot and after amending some of the columns in the data page. I have then gone to refresh the pivot table. Although there is no longer any cells with the old data the option to select the old data is still being shown although it contains no info |
Thanks Roger/ anyone else
That seemed to have solved the problem for a minute, when using the manual way but as soon as I drag back pivot field the old items still appear. When the pivot field is away from the pivot table the old items do not appear in the list but when dragged back they still do. "Roger Govier" wrote: Hi Take a look here to see methods for clearing old items both manually and programmatically. http://www.contextures.com/xlPivot04.html Regards Roger Govier Accountant Williams wrote: I have created a pivot and after amending some of the columns in the data page. I have then gone to refresh the pivot table. Although there is no longer any cells with the old data the option to select the old data is still being shown although it contains no info |
Hi
Did you click on Refresh whilst the field was removed from the table? The other thing I have often found to work, is to click on the field name whilst in the PT, then press refresh. Regards Roger Govier Accountant Williams wrote: Thanks Roger/ anyone else That seemed to have solved the problem for a minute, when using the manual way but as soon as I drag back pivot field the old items still appear. When the pivot field is away from the pivot table the old items do not appear in the list but when dragged back they still do. "Roger Govier" wrote: Hi Take a look here to see methods for clearing old items both manually and programmatically. http://www.contextures.com/xlPivot04.html Regards Roger Govier Accountant Williams wrote: I have created a pivot and after amending some of the columns in the data page. I have then gone to refresh the pivot table. Although there is no longer any cells with the old data the option to select the old data is still being shown although it contains no info |
Hi Roger
Solved it now. What I had not fully got from the Contextures Tips was that you take out the field while in the wizard format and then refresh. I was just moving it around in the PT format. Thanks for your help. "Roger Govier" wrote: Hi Did you click on Refresh whilst the field was removed from the table? The other thing I have often found to work, is to click on the field name whilst in the PT, then press refresh. Regards Roger Govier Accountant Williams wrote: Thanks Roger/ anyone else That seemed to have solved the problem for a minute, when using the manual way but as soon as I drag back pivot field the old items still appear. When the pivot field is away from the pivot table the old items do not appear in the list but when dragged back they still do. "Roger Govier" wrote: Hi Take a look here to see methods for clearing old items both manually and programmatically. http://www.contextures.com/xlPivot04.html Regards Roger Govier Accountant Williams wrote: I have created a pivot and after amending some of the columns in the data page. I have then gone to refresh the pivot table. Although there is no longer any cells with the old data the option to select the old data is still being shown although it contains no info |
You're welcome.
Glad you got it sorted. Regards Roger Govier Accountant Williams wrote: Hi Roger Solved it now. What I had not fully got from the Contextures Tips was that you take out the field while in the wizard format and then refresh. I was just moving it around in the PT format. Thanks for your help. "Roger Govier" wrote: Hi Did you click on Refresh whilst the field was removed from the table? The other thing I have often found to work, is to click on the field name whilst in the PT, then press refresh. Regards Roger Govier Accountant Williams wrote: Thanks Roger/ anyone else That seemed to have solved the problem for a minute, when using the manual way but as soon as I drag back pivot field the old items still appear. When the pivot field is away from the pivot table the old items do not appear in the list but when dragged back they still do. "Roger Govier" wrote: Hi Take a look here to see methods for clearing old items both manually and programmatically. http://www.contextures.com/xlPivot04.html Regards Roger Govier Accountant Williams wrote: I have created a pivot and after amending some of the columns in the data page. I have then gone to refresh the pivot table. Although there is no longer any cells with the old data the option to select the old data is still being shown although it contains no info |
All times are GMT +1. The time now is 12:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com