Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial![](https://ecs-static.teamtreehouse.com/assets/views/marketing/shared/community-banner-white-47072046c51352fe6a69f5e691ff5700b28bb11d45197d7bdf066d9ea3f72d0c.webp)
![Mark Chesney](https://uploads.teamtreehouse.com/production/profile-photos/10045392/micro_1.jpg)
Mark Chesney
11,747 PointsLibreOffice Calc - how to perform advanced pivot table tips (such as autoupdate after adding row)
Hi! So this is my second LibreOffice Calc* question.
In the video, we see how the pivot table automatically updates after a row is added, e.g. a new city in the Store Data
worksheet. As we saw in the earlier video, we can designate the table as a table (a named object) in Excel. My question: is there a way to do this equivalent action in LibreOffice Calc? I've formatted it as a nice table by clicking Format
-> AutoFormat Styles...
; though this made it look pretty, LibreOffice Calc didn't designate this as a table.
Thanks in advance!
*LibreOffice Calc is the open source equivalent of Microsoft Excel, which is available for the Linux Mint operating system. And I'm new to it :)
1 Answer
![Mark Chesney](https://uploads.teamtreehouse.com/production/profile-photos/10045392/micro_1.jpg)
Mark Chesney
11,747 PointsI am SO silly! I asked the question before finding out that the video had the answer -- just click Refresh
in the Pivot Table! ¯_(ツ)_/¯