When I click on the pivot table, I want it to default to a cell ref (a9) rather than a getpivotdata function. any idea how?
2007-03-05 06:08:40 · 3 answers · asked by tommyv 1 in Computers & Internet ➔ Software
rather than clicking on the cell in the pivot table, just enter the cell reverence directly like.. "Sheet1!C3"
have u tried this website www.excelgoodies.com , may be u can visit them, they got solutions for ur excel problems.
2007-03-09 03:56:29 · answer #1 · answered by sam e 2 · 0⤊ 0⤋
reinstall 2000 then. there are incredibly some great advancements to pivot tables from 2000 to 2003 as you will detect in case you provide it a raffle. you are able to in simple terms link to the cellular handle in case you decide directly to. it somewhat is slightly cumbersome besides the undeniable fact that it works as nicely.
2016-10-17 08:10:29 · answer #2 · answered by ? 4 · 0⤊ 0⤋
You can create a new column with the formula row() so that when you drill down you know which row the data came from.
2007-03-05 14:31:20 · answer #3 · answered by unnga 6 · 0⤊ 0⤋