Mar 10 2020 09:29 PM
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 ?
Mar 11 2020 06:34 AM
SolutionMar 11 2020 06:34 AM
Solution