My background:
I am a strong user of Excel, but not experienced in VBA code. I am proficient in "Recording Macros"
I have a 25,000 row set of data which is replaced each month with new data, but has an identical column structure and formats.
I have several macros built which then cleanse the data
I then use Macros to create 3 pivot tables which summarize the data.
One of these pivot tables requires a Distinct Count, which I get my using the "Add this data to the Data Model" Pivot Table Option.
Everything works fine, until I save the file with a new name and in a new folder.
When I do that, the macro that creates the Distinct Count references the data in the old folder.
Any ideas on how to fix this?
I am a strong user of Excel, but not experienced in VBA code. I am proficient in "Recording Macros"
I have a 25,000 row set of data which is replaced each month with new data, but has an identical column structure and formats.
I have several macros built which then cleanse the data
I then use Macros to create 3 pivot tables which summarize the data.
One of these pivot tables requires a Distinct Count, which I get my using the "Add this data to the Data Model" Pivot Table Option.
Everything works fine, until I save the file with a new name and in a new folder.
When I do that, the macro that creates the Distinct Count references the data in the old folder.
Any ideas on how to fix this?