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

Data Analysis Intermediate Excel Pivot Tables Other Pivot Table Tips and Tricks

Posted by Mark Chesney
Mark Chesney
11,747 Points

LibreOffice 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
Mark Chesney
11,747 Points

I am SO silly! I asked the question before finding out that the video had the answer -- just click Refresh in the Pivot Table! ¯_(ツ)_/¯