[tdf-discuss] Re: Pivot data does not refresh

On 1/1/2012 2:52 PM, dave_ wrote:
> 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.
Is the range for the pivot table large enough to include the new data? 
If not, then you wouldn't see a change.


--
Unsubscribe instructions: E-mail to discuss+help@documentfoundation.org
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