Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Source
Numerous pivot reports are generated from a separate base data file. All the
reports files and the data file are currently under one folder, however, I would like to move the base data file to a separate folder (and leave the reports where they currently are). I tried moving it, but the reports lose the link to the base data. Is there a way to move the source data file and still ensure the pivot reports still point to it? (without having to go into each report and repoint the file... there are too many reports for this). Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Source
Perhaps the Pivot Play add-in at Debra Dalgleish's website:
http://www.contextures.com/xlPivotPlay01.html Does that help? *********** Regards, Ron XL2002, WinXP "MLK" wrote: Numerous pivot reports are generated from a separate base data file. All the reports files and the data file are currently under one folder, however, I would like to move the base data file to a separate folder (and leave the reports where they currently are). I tried moving it, but the reports lose the link to the base data. Is there a way to move the source data file and still ensure the pivot reports still point to it? (without having to go into each report and repoint the file... there are too many reports for this). Thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Source
Looks interesting. I will give it a try. Thanks alot.
"Ron Coderre" wrote: Perhaps the Pivot Play add-in at Debra Dalgleish's website: http://www.contextures.com/xlPivotPlay01.html Does that help? *********** Regards, Ron XL2002, WinXP "MLK" wrote: Numerous pivot reports are generated from a separate base data file. All the reports files and the data file are currently under one folder, however, I would like to move the base data file to a separate folder (and leave the reports where they currently are). I tried moving it, but the reports lose the link to the base data. Is there a way to move the source data file and still ensure the pivot reports still point to it? (without having to go into each report and repoint the file... there are too many reports for this). Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Size | Charts and Charting in Excel | |||
Q: Change pivot table source path? | Excel Discussion (Misc queries) | |||
verify pivot table source | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) |