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?
 
Ad

Advertisements


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

Top