Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table as a source cell -
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html Teresa wrote: Had Excel 95 worksheet with PivotTable as a source for several other tables on different tabs. Company upgraded to Windows 2003 and now cannot use the copy and paste function to find correlating PivotTable cells. E.g., Table 1, Cell A1 = Pivot Cell A1, then copy that down in the table and everything is perfect in 95, but 2003 version get error messages all over the place and at one point document would not even save. IT appears the problem is the new labeling feature in the Pivot Table - can it be turned off or is there a work around. Am desperate. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Pivot Table report discarded in Excel 2003 - any fix available? | Excel Discussion (Misc queries) | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |