How do I find Origin of an excel sheet?

I am trying to answer this question>What is the most common origin? How many cases have that origin?

excel

HansVogelaar
Jun 18, 2021
aimes_12

If B1 contains a umber of hours, for example 36, you can use

=B1/24

to return 1.5 as the number of days

NikolinoDE

Platinum Contributor

Jun 18, 2021

aimes_12

Find out which data sources are used in a workbook data model

In Excel, click Power Pivot > Manage to open the Power Pivot window.
View the tabs in the Power Pivot window. Each tab contains a table in your model. ...
To view the origin of the table, click Table Properties.

Find out which data sources are used in a workbook data model

If you're working with data that's been added to an Excel data model, then sometimes, you may lose track of which tables and data sources were added to the data model.

Note: Make sure you have enabled the Power Pivot add-in. For more information, see Start the Power Pivot add-in for Excel.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.