| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to pivot table data
One of my colleagues has a worksheet where cells are linked to data into
pivot tables created in external documents. She has not made changes to the external document with the pivot tables. Despite this, when she refreshes the data in the new document, it somehow resets the cell reference to $A$2 and gives her a "#Ref" error in the cell. Can someone explain what is causing this and how to get around it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link to pivot-table | Excel Discussion (Misc queries) | |||
| how do I link pivot table data into a separate document? | Excel Worksheet Functions | |||
| How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
| Change link in pivot table | Excel Worksheet Functions | |||
| how do i link to a pivot table to get data dynamically | Excel Worksheet Functions | |||
Linear Mode
