Suggestion To tell if data in a worksheet is shaped by Energy Query, select a cell of data, and In the event the Query context ribbon tab seems, then the data was loaded from Electrical power Question.Remember that if another person is applying OneDrive to sync information, variations they make whilst their Personal computer is offline is not goi
Suggestion To tell if knowledge in a worksheet is shaped by Electrical power Query, pick out a mobile of information, and If your Query context ribbon tab seems, then the data was loaded from Electricity Question.When they're working with A different Model, like Excel Cellular, then their selections will not likely look to you. Having said that,
If just one human being does this, then All people else can get the "locked" error—whether or not Anyone else is employing a Edition of Excel that does aid co-authoring.Take into account that if a person is employing OneDrive to sync information, variations they make when their Personal computer is offline is not going to get merged right up unti