Refresh A Pivot Table - Apple Support (SG)

• Apple
• • Store
  • Mac
  • iPad
  • iPhone
  • Watch
  • Vision
  • AirPods
  • TV & Home
  • Entertainment
  • Accessories
  • Support
• 0+

Numbers User Guide for iCloud Open Menu Close Menu

• Communities

Numbers Table of Contents

Numbers User Guide for iCloud

• Welcome
• What’s new in Numbers for iCloud
• Numbers basics
  • Intro to Numbers for iCloud
  • Intro to tables and other objects
  • Create a spreadsheet
  • Organize with sheets
  • Change the sheet background
  • Upload a spreadsheet
  • Sync a spreadsheet
  • Print a spreadsheet
  • Change the spreadsheet view
  • Troubleshooting
    • If you can’t find a spreadsheet
    • Resolve spreadsheet conflicts
• Add and style tables
  • Add or delete tables
  • Select cells, rows, columns, or tables
  • Add or change rows and columns
  • Merge and unmerge cells
  • Change the look of text, rows, and borders
    • Change the look of table text
    • Change table gridlines and colors
  • Format tables for bidirectional text
• Add table data and formulas
  • Enter text and numbers
  • Add formulas
  • Change an existing formula
  • Add checkboxes and other controls
  • Clear cell content and formatting
  • Format as currency or other data
  • Use Formulas and Functions Help
• Sort, filter, and organize tables
  • Alphabetize or sort data
  • Filter data
  • Organize data into categories
    • Intro to categories
    • Add or edit categories
    • Edit groups in a categorized table
    • Summarize group data
  • Create pivot tables
    • Intro to pivot tables
    • Create a pivot table
    • Add and arrange pivot table data
    • Change how pivot table data is sorted and grouped
    • Refresh a pivot table
    • View the source data for a value
• Add charts
  • Create or delete a chart
  • Edit chart data
  • Edit chart text and markings
  • Change how data is displayed
  • Change the chart background
  • Change a chart’s type
• Add text
  • Add text to a spreadsheet
  • Select text
  • Copy and paste text
  • Add bulleted or numbered lists
  • Format text and characters
    • Change the font, size, style, or color of text
    • Apply preset paragraph styles in Numbers for iCloud
    • Add drop caps
    • Raise and lower text
    • Add a shadow to text
    • Change text capitalization
  • Align and space text
    • Adjust alignment and spacing
    • Format columns of text
    • Adjust character spacing
  • Add borders and rules (lines)
  • Add a background color to text
  • Link to a website, email, phone number, or sheet
  • Work in other languages
    • Write in another language
    • Change the text direction
    • Create a spreadsheet with the formatting of a different language
• Add images, shapes, and media
  • Images
    • Add or replace images
    • Add an image gallery
    • Crop (mask) an image
  • Shapes and lines
    • Add shapes and lines
    • Edit shapes and lines
    • Combine or break apart shapes
    • Add text inside a shape
  • Add video and audio
• Position and style objects
  • Position objects on a sheet
    • Move and align objects
    • Resize objects
    • Rotate or flip objects
    • Connect objects with a line
    • Place objects inside a text box or shape
    • Layer, group, and lock objects
  • Customize the look of objects
  • Add a title or caption
  • Apply object styles
  • Fill shapes and text boxes with colors or images
• Share and collaborate
  • Email a spreadsheet
  • Collaborate with others
    • Intro to collaboration
    • Invite others to collaborate
    • Collaborate on a spreadsheet
    • Change shared spreadsheet settings
    • Stop sharing spreadsheets
    • Shared folders and collaboration
    • Use Box to collaborate
• Manage spreadsheets
  • Save, name, or duplicate spreadsheets
  • Delete or recover spreadsheets
  • Restore earlier versions
  • Organize spreadsheets
  • Password-protect spreadsheets
  • Download spreadsheets
• Writing and editing tools
  • Spell-check text
  • Find and replace text
  • Add or reply to comments
  • Set your author name and color
• Keyboard shortcuts
• Legal notices and acknowledgements
• Copyright

If you make changes to the source data for a pivot table, you need to refresh the pivot table to see the changes reflected.

1. Click anywhere in the pivot table.

2. In the Pivot Options tab of the Organize  sidebar, click the Refresh button .

   

   The pivot table changes to show the updated information.

   Tip: You can also Control-click (on a Mac) or right-click (on a Windows device) the pivot table, then choose Refresh Pivot Table.

See alsoIntro to pivot tables in Numbers for iCloudCreate a pivot table in Numbers for iCloudAdd and arrange pivot table data in Numbers for iCloud Previous Change how pivot table data is sorted and grouped Next View the source data for a value Helpful? Yes No Character limit: 250 Please don’t include any personal information in your comment. Maximum character limit is 250. Submit Thanks for your feedback.