Pivot Table - Reference is not valid

  • Thread starter Thread starter Sinner
  • Start date Start date
S

Sinner

I have a list in a file name abc.xls. I have defined the list with a
name say XYZ.
I have another file Summary.xls with a pivot table that I'm using to
give me a summary of that list.
The 'XYZ' which is the defined name of the actual list in abc.xls file
works when both the files are open.

When I open the Summary.xls file, first message says "Reference is not
valid" and second message says "Cannot find "abc.xls file".

If I first open the abc.xls file and then the summary.xls, then it
works and not viceversa.

Please update.

Thx.
 
As answered in microsoft.public.excel.misc and
microsoft.public.excel.worksheet.functions:

If you create the pivot table using the other Excel file as external
source, you won't have to open the source file to update the pivot table.

To change the source, right-click on a cell in the pivot table, and
choose PivotTable Wizard
Click the Back button until you reach Step 1
Choose External data source, and click Next
Click Get Data, and connect to the source Excel file and table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enter File name in cell 2
Macro to paste value to a file same as A1 10
Save file from the value of cell in different opened file 2
reference a closed filed from a cell and formula in an open file 15
hiding 0 from a cell 4
2. Why this happening in Excel everytime? 1
Check if a workbook has an "open password" 1
Copy Autofiltered rows to another workbook using macro 2

Back
Top