i want to query external data into excel, meanwhile the file should be shared so several people could edit at same time, power query can’t be used in shared file, is there any other excel build-in function could achieve?

i know macro could achieve, but wonder is there any excel build-in function