Good Morning All. Some users have encountered problems or technical execution of the Function: GETPIVOTDATA?
Application: CALC Operation: Function GETPIVOTDATA Structure Function: Field 1: Database area = By entering the data (also referred to as a name), the function ignores them; Field 2: Pivot Table reference = entering the data (also referred to as a name), the function does not recognize the address; Field 3: cell index = on the data, but the function does not give the correct result. Reason operation: Some data of the Data Base Pivot table source of origin have changed Structure of the worksheet and what happens: Two Pivot Tables data is transferred on 2 different columns of a worksheet. The function is not in any of the results from two columns of data the response in the cells is # REF! *I specify that it is important: the worksheet in question is the accounting balance sheet of a company.* * * *You've never seen an accountant who commits suicide from the tower? This is a good occasion!* Thanks for your attention, waiting for some user can verify the same problem. -- http://contabilmenteag.wix.com/contabilmenteag-net contabilmenteag....@gmail.com contabilment...@hotmail.it Ras Michele Perito Agrario Salita S.Barnaba 24d/18 16136 Genova Ge Tel./Fax.: 010 213059 Tel.Mobile:3201107102 **** Riservatezza / Confidentiality **** In ottemperanza al D.Lgs. n. 196 del 30/6/2003 in materia di protezione dei dati personali, le informazioni contenute in questo messaggio sono strettamente riservate ed esclusivamente indirizzate al destinatario indicato (oppure alla persona responsabile di rimetterlo al destinatario). Vogliate tener presente che qualsiasi uso, riproduzione o divulgazione di questo messaggio รจ vietato. Nel caso in cui aveste ricevuto questo messaggio per errore, vogliate cortesemente avvertire il mittente e distruggere il presente messaggio. According to Italian law D.Lgs. 196/2003 concerning privacy, if you are not the addressee (or responsible for delivery of the message to such person) you are hereby notified that any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted