Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to Pivot
How do you turn off the long references when you linked to Pivot table cell?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to Pivot
Hi,
In 2003 - add the GetPivotData toolbar button to the PivotTable toolbar and then you can toggle this feature on and off. To add the button choose View, Toolbars, Customize, Commands tab, Data category, and scroll to the bottom of the list of buttons, drag the above mentioned tool to the toolbar. In 2007 - Choose PivotTable Tools, Options, open the Options drop down and choose Generate GetPivotData. You can add this button to the QAT by right clicking it and choosing Add to Quick Access Toolbar. In 2003 & 2007 - don't click in the pivot table as you build your formula, instead type the cell reference manually, for example, type =C10 rather than clicking on C10. -- Cheers, Shane Devenshire "Dinesh" wrote: How do you turn off the long references when you linked to Pivot table cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i link pivot tables | Excel Worksheet Functions | |||
link to pivot-table | Excel Discussion (Misc queries) | |||
Link Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables lost link | Excel Discussion (Misc queries) | |||
deactivate the get pivot formula when I link a cell to a pivot | New Users to Excel |