Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a file to a Pivot Table in another file
I have a sumamry file for monthly reporting that is linked to four different
files (each with a pivot table). With all the files open, I refresh the data of each pivot table, save them and voila! the summary file is updated and saved. **The issue I have is when I close all the files with pivot tables, the summary file shows me "#REF" in the cells with the links to teh tables. Not sure why, any ideas are greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
How to make the Embedded Excel file link to the table of Access | Links and Linking in Excel | |||
Pivot Table Source Link changed when file saved to SharePoint site | Excel Discussion (Misc queries) | |||
How to set up a pivot table from a csv file | Excel Discussion (Misc queries) | |||
Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) |