0
How do you find what sheet or where the data came from in an Excel pivot table?
Wiki User
∙ 14y ago
Excel 2007:
- Click on any cell of Pivot table.
- Click on the Options Tab for PivotTable Tools.
- In the Data section, click on Change Data Source icon, then the Change Data Source item from the drop-down menu.
- Observe the Table/Range in the Change PivotTable Data Source window.
Excel 2003:
- Click on any cell of Pivot table.
- Open the Data menu and select Pivot Table.
- In Pivot Table Wizard use Back button and change address of the source data.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is the Microsoft version of Excel before 2013 came out?
Microsoft Excel 2010.
What did jobs do before Excel was created?
They either used other spreadsheet applications, or calculators or paper. Excel was not the first electronic spreadsheet. Excel came out in 1985, but the first electronic spreadsheet was VisiCalc, which came out in 1979. There were others between VisiCalc and Excel, most notably Lotus 1-2-3.
Who came up with periodic table?
Dmitri Mendeleev came up with the modern Periodic Table in 1869.
Which was first Lotus 1 2 3 or Excel?
Lotus 123 came before Microsoft Excel by about 2 years.
When did Microsoft Excel come out?
The first Spreasheet was called Visicalc, invented in 1978 by Bob Frankston and Dan Bricklin. Other spreadsheet applications followed, like Lotus 1-2-3.The first version of Microsoft Excel came out in 1985 for the Mac, and a version for a PC in 1987.
Where can you find the sheet music to i came?
type in on google lyrics to i came itsusually the first one
When did table tennis start and how?
table tennis didn't came from china
History of table tennis in the Philippines When did the Philippine adapted table tennis When was table tennis introduced to the oylmpics?
i belive it came to the Olympics in 2000
What happened when Excel spreadsheet was established?
Spreadsheets existed before Microsoft Excel. Visicalc was the first one, launched in 1979. The first version of Excel came out in 1985. All that really happened then was that Microsoft now had a spreadsheet application. Microsoft Excel is now the most popularly used of the many spreadsheet applications.
The check engine light came on on my 1991 Hyundai Excel SE. There was no flicker and it just came on today. How do I resolve the problem?
Have vehicle scanned to determine the problem
Who came up with the idea of the periodic table?
Dmitri Mendeleev
How do you undo Excel save file?
I had one day when I came across a very compound issue connected to excel file. To my good fortune I could work out such problem and perhaps it might be useful for this trouble.
