Mar 10 2020
When I refresh the pivotTable by a linked file,error appear,that problem lead by the changed name of the taget worksheet of linked file.
That taget worksheet's name change by other staff every week.
The taget worksheet is the 1st worksheet of the linked file.
In the pivotTable linked import data setting,
How can I set the taget worksheet by "the 1st worksheet" of the file,not by the "worksheet name" of the file ?
View best response
Mar 11 2020