What Pivot Table toolbar button updates the data in a Pivot Table or - ProProfs Discuss
Topics-
Products +
     

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed?

This question is part of Excel Basic Questions by Akshay Magre
Asked by Pavan, Last updated: Sep 02, 2019

+ AnswerRequest Answer
...

2 Answers

E. Barnes

But Can you play this?

E. BarnesProfessional Gamer, Professional Gamer, Washington
Professional Gamer, Professional Gamer, Washington

Answered on Jul 15, 2019

The correct answer to this question is to Refresh data. This technique would be used in the Microsoft spreadsheet software, Microsoft Excel. Refresh data allows one to refresh the data in an excel workbook from a connected data source. Those sources could be a cell range, text file, or Web query.

The steps for refreshing differ based on the connected data source. Each time the data is refreshed, the data source will show the most updated version. Any changes that are made will be reflected in the data source. For security purposes, the computer must allow the connected data source to view the updated versions.

 Reply

Pavan

Pavan

Answered on Oct 17, 2018

Refresh Data
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.