Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIVOT TABLE HELP (PLEASE) - REPOST
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? -- "Loose Change 2nd Edition" has been seen by almost 7 million people on Google video |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIVOT TABLE HELP (PLEASE) - REPOST
I had a "stupid" moment "scubadiver" wrote: 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? -- "Loose Change 2nd Edition" has been seen by almost 7 million people on Google video |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Repost: Pivot Table | Excel Discussion (Misc queries) |