When I create a "Pivot data" sheet and then went I need to 'refresh' the pivot data sheet (sheet 2) I am unable to do update. I have to re-create the data sheet every time I add something to the main sheet (sheet 1).
Is there something I am or have done already that prevents me for just refreshing sheet 2? Background: I have created a small dept inventory worksheet, so when things are added or removed I just open (sheet 2) and would it refresh but it does not exists. I can create it easy and as long as I don't close the worksheet sheet down it works fine. But if I close it and then open it and add to the main spreadsheet new or delete an inventory item, it fails to update using the refresh command in the pivot data spreadsheet (sheet 2). Any suggestion on what to do, I would appreciate it very much. Thanks, -dave_ -- View this message in context: http://nabble.documentfoundation.org/Pivot-data-does-not-refresh-tp3625307p3625307.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
