Help with pivot table "refresh" please

asked 2018-04-04 01:35:06 +0200

rk392 gravatar image

updated 2018-04-04 01:35:24 +0200

LibreOffice Calc Version: 5.0.6.3

If I add data to empty rows in the pivot table's source field, then right click the pivot table and select "Refresh", the pivot table does NOT refresh.

In order to refresh the pivot table, I have to right click, select "Edit Layout" to launch the Pivot Table Layout window, then select "OK".

How can I get the "Refresh" option to actually refresh? Or is Refresh only for changes in existing data, and not for adding data to empty cells that are already in the pivot table's source field of cells?

edit retag flag offensive close merge delete

Comments

Your Operating System? LibO 5.0.6 is rather old now. It was a very fresh version (see the 0 in the second position) and may have been buggy with this respect. Try V 5.4.6.

Lupp gravatar imageLupp ( 2018-04-04 09:05:32 +0200 )edit

Windows 7. I'll give 5.4.6 a try, thanks.

rk392 gravatar imagerk392 ( 2018-04-04 16:46:00 +0200 )edit