| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I link pivot table data into a separate document?
I created a tab in the pivot table document with links to the pivot table
using the GETPIVOTDATA function. Then I moved the tab with the links into a new file. When I closed the new file and opened it back up, I am full of Reference errors. The GETPIVOTDATA function formula looks fine but does not give me the data that I need. Does anyone have any idea why? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I link pivot table data into a separate document?
The GETPIVOTDATA function, like some other functions, only returns data
for references in the same file, or another open file. http://support.microsoft.com/default.aspx?id=299303 If you open the other workbook, the formula results should work correctly. Hendy wrote: I created a tab in the pivot table document with links to the pivot table using the GETPIVOTDATA function. Then I moved the tab with the links into a new file. When I closed the new file and opened it back up, I am full of Reference errors. The GETPIVOTDATA function formula looks fine but does not give me the data that I need. Does anyone have any idea why? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
| how do i link to a pivot table to get data dynamically | Excel Worksheet Functions | |||
| separate data in a table | Excel Discussion (Misc queries) | |||
| Pivot Table in separate workbook | Excel Discussion (Misc queries) | |||
| Incorporation of Data Into Separate Document | Setting up and Configuration of Excel | |||
Linear Mode
