Pivot Table Data Range Folder

103392

New Member
Joined
Aug 21, 2006
Messages
9
Is there a way to use VBA or other solution to have my pivot tables point to the same file name and range, but in different folders?

For example, I have a folder named 2010-MAY. I have pivot tables that update from a file in that folder called Data.xls. The file has a text-import range called DataUpdate. The path to the dataset is '\\2010-MAY\Data'!DataUpdate. I would like to be able to copy the entire 2010-MAY folder, rename it 2010-JUNE, and somehow have the pivot table range location be updated automatically to '\\2010-JUNE\Data'!DataUpdate.

I think I'm looking for a way to set the range to a relative reference to '\\Data'!DataUpdate, perhaps using VBA.

Thanks!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,118,053
Messages
5,569,901
Members
412,298
Latest member
dietitiann
Top