Yes, I did increase the range (to 1000) while I currently only have about 250 rows.
I add the change every time I create the pivot data hoping this time it will take. By any chance, does Calc remember any old data that may prevent the data sheet from working correctly? On Sun, Jan 1, 2012 at 12:31 PM, Gene Kohlenberg [via Document Foundation Mail Archive] <ml-node+s969070n3625355...@n3.nabble.com> wrote: > 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 [hidden > email]<http://user/SendEmail.jtp?type=node&node=3625355&i=0> > 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 > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://nabble.documentfoundation.org/Pivot-data-does-not-refresh-tp3625307p3625355.html > To unsubscribe from Pivot data does not refresh, click > here<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3625307&code=ZGF2ZS53YWduZXIwOEBnbWFpbC5jb218MzYyNTMwN3wtMTIxMzg2NjQ5Mw==> > . > NAML<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.InstantMailNamespace&breadcrumbs=instant+emails%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://nabble.documentfoundation.org/Pivot-data-does-not-refresh-tp3625307p3625461.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to discuss+h...@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
