PIVOT TABLE HELP (PLEASE) - REPOST

G

Guest

I didn't get a response yesterday and it is already on page 3.


I have a source workbook with lots of tabs. I have separate workbooks that
reference the columns in one worksheet from the source.

All of these workbooks are in the same folder.

The columns in the workbook are then used to create a pivot table (within
the same work book)

When I try to refresh the data I get this error:

"Cannot open pivot table source file"

The other error I get is "pivot table not valid" ???????

Any ideas?
 

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

Cannot Open Pivot Table Source File 0
pivot table data 2
Column limit for Pivot Table data source 1
Pivot tables - memory issues - please help 2
Refreshing a pivot table 1
Pivot Table New Data 4
Refresh order when refreshing all in a workbook 1
Referencing a pivot tables Grand Totals Column 1

Top