SOLVED

Inquire about PivotTable with importing worksheet of linked file

%3CLINGO-SUB%20id%3D%22lingo-sub-1221418%22%20slang%3D%22zh-CN%22%3EInquire%20Pivot%20Table%20with%20importing%20ping%20out%20linked%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1221418%22%20slang%3D%22zh-CN%22%3E%3CP%3EWhen%20I%20refresh%20the%20pivottable%3CBR%20%2F%3Eby%20a%3CBR%20%2F%3Elinked%20file%2C%20error%20view%2C%20the%20one%20lead%20by%20the%20changed%20name%20of%20the%20taget%20worksheet%20of%20linked%20file.%3C%2FP%3E%3CP%3EThat%20taget%20py's%20name%20change%20by%20other%20staff%20staff%20week%20every.%3C%2FP%3E%3CP%3EThe%20taget%20worksheet%20is%20the%201st%20worksheet%20of%20the%20linked%20file.%3C%2FP%3E%3CP%3EIn%20the%20pivotTable%20linked%20import%20data%20setting%2C%3C%2FP%3E%3CP%3EHow%20can%20I%20set%20the%20taget%20worksheet%20by%20%22the%3CBR%20%2F%3E1st%20worksheet%22%20of%20the%20file%2C%20not%20by%20the%20%22worksheet%20name%22%20of%20the%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1221418%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222095%22%20slang%3D%22en-US%22%3ERe%3A%20Inquire%20about%20PivotTable%20with%20importing%20worksheet%20of%20linked%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222095%22%20slang%3D%22en-US%22%3ECan%20you%20define%20a%20range%20name%20which%20points%20to%20the%20data%20you%20need%20for%20your%20pivottable%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

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 ?

1 Reply
best response confirmed by adlih (Occasional Contributor)
Solution
Can you define a range name which points to the data you need for your pivottable?