Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to use the contents of a cell for a data range in a pivot tabl
Background: I use pivot tables for data that is stored in a separate
worksheet (source file) in order to save space and reduce clutter in the source file. I use a range name for the data in the source file so that when I refresh my pivot tables, it looks for any additional rows and columns. All works fine, however, I have a periodic need to change the location and name of the source file. Question: Is there a way that I can put the location -and- file name in a cell and have the pivot tables reference the contents of that cell in order to get the new source file location and name. Please advice. Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting Data in a Cell | Excel Worksheet Functions | |||
How do I chart the same data cell on a range of worksheets? | Charts and Charting in Excel | |||
Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |